• Merge two SQL Server databases

    I have two SQL Server databases and they have the same schema. But both may have issues with the primary key in some tables (so I want to get rid of the duplicate rows). How can I merge these two databases? Appreciate any help available.

    ITKE413,335 pointsBadges:
  • Delete duplicate records in MySQL database

    One of our clients asked us to delete duplicate records in a SQL Server database and a MySQL database. We did it in SQL but MySQL is giving us issues. It says the format of the query is not correct. Does anyone know of a way to do this? Thank you so much!D

    ITKE413,335 pointsBadges:
  • Close existing connections on SQL Server database

    I'm trying to close all of my existing connections to SQL Server - I have to do a complete restore for my database. Here's what I tried so far: alter database YourDb set single_user with rollback immediate But I keep getting this message: Connection was not closed. What should I do?

    ITKE413,335 pointsBadges:
  • Make SQL Server primary key AUTO INCREMENT

    In SQL Server, I have a database with a table and the primary key is titled 'ID'. Is there a way I can make it AUTO INCREMENT? Thanks so much.

    ITKE413,335 pointsBadges:
  • How to check if role exists in SQL Server database

    I need to add several users, in the same role, on multiple SQL Server databases. But that role can't be present too. How would I be able to check if an actual role exists in my database?

    ITKE413,335 pointsBadges:
  • Compare SQL Server and Oracle databases

    Our department currently has an SQL Server database and Oracle database. One of the tables is labeled 'Inventory' - which has thousands of rows from both databases and it will continue to grow over time. Now, here's what we need to do: We have to compare the Oracle data to the SQL Server data so we...

    ITKE413,335 pointsBadges:
  • Create foreign key in Oracle using ON UPDATE CASCADE

    I'm working with both Oracle and SQL Server. And in SQL, I created a foreign key with the ON UPDATE CASCADE option. So basically, whenever I update the column in the primary key - all of the other foreign keys (in tables) will be updated too. But I'm not sure how to do this in Oracle. Can someone...

    ITKE413,335 pointsBadges:
  • Change data path for existing SQL Server database

    My SQL Server has between 15-20 databases running on it. Now, because I'm running out of space, I'm looking to move my data path to another drive. How can I go about doing this? What SQL command should I use?

    ITKE413,335 pointsBadges:
  • How to get number of fields in SQL Server database

    Would I be able to get the number of fields in my SQL Server database with some sort of SQL statement? I'm talking about all the entries in my database. Thank you.

    ITKE413,335 pointsBadges:
  • How to create SQL Server database programmatically

    How can I go about creating a SQL Server database programmatically? I don't want to use SQL Server Management Object API. Is there another way to do it?

    ITKE413,335 pointsBadges:
  • Compare columns in two SQL Server tables

    I just did a SQL Server migration from an old version to the newest one but I've run into a few issues. Is there a query out there that could compare columns in two different tables? I have to compare the actual columns - not the data. Can someone help me?

    ITKE413,335 pointsBadges:
  • Error message when entering data into SQL Server database

    For the past few days, I've been trying to enter my data into my SQL Server database but I keep getting this error: Invalid column name. Is there any reason why I'm getting this error?

    ITKE413,335 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE413,335 pointsBadges:
  • Best format to store images in SQL Server database

    For my SQL Server database, what's the best format to store images? Would binary be the best bet? Thanks so much.

    ITKE413,335 pointsBadges:
  • Copy and rename SQL Server 2008 database

    We currently have a SQL Server 2008 database that needs to be copied and renamed as a new database. We're not too worried about losing data - it's a new database. Basically - we want to keep the same structure as the old database / set a new name to it. What's the best way to do this?

    ITKE413,335 pointsBadges:
  • T-SQL script for list of SQL Server 2008 R2 databases and user privileges

    Does anyone know if there's a T-SQL script that would list all of our SQL Server 2008 R2 databases and the roles / privileges for one specific user? Thank you very much.

    ITKE413,335 pointsBadges:
  • Data migration from SQL Server to Oracle

    For my job, I have to move over data (particularly table data) from SQL Server to Oracle. This usually happens on a weekly basis. What's the best way to do it automatically / repeatedly? Thank you.

    ITKE413,335 pointsBadges:
  • Select permissions for user on SQL Server 2008 database

    I have to create a new user on our SQL Server 2008 database with only select permissions. This user will have read-access only. Is there a way to do this? Thanks.

    ITKE413,335 pointsBadges:
  • SQL Server 2012 error message when restoring database

    I keep getting this odd error message in SQL Server 2012 when I'm trying to restore a backup that was made from a previous version. Here's the error message I'm getting: System.Data.SqlClient.SqlError: Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL...

    ITKE413,335 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

    Lstadler15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following