• How to export SQL Server 2012 database with data

    Can I import my SQL Server 2012 database (including the data) to a .SQL file so I can import it into my 2008 server. For some reason, I've never been able to export the data. Only the structure goes through.

    ITKE435,945 pointsBadges:
  • Restoring SQL Server 2008 database backup over my network

    Does anyone know how I can restore a SQL Server 2008 database backup over my network? Do I have to copy the file locally to the SQL Server? Thanks for the help.

    ITKE435,945 pointsBadges:
  • Compare two table schemas in SQL Server database

    Throughout my week, I have to do random checks between a SQL Server development and release database. Usually - this is a manual process but it's quite slow now. Would I be able to compare my different table schemas automatically? Thank you very much.

    ITKE435,945 pointsBadges:
  • Backup SQL Server 2008 database using C#

    How can I backup my SQL Server database (2008 edition) using C#? Is there a specific code I have to write? Can I use SQLConnection? Appreciate the help.

    ITKE435,945 pointsBadges:
  • Count empty tables in SQL Server database

    In SQL Server, would there be a way for me to count the tables with no rows? Can I use a T-SQL statement? Thank you very much.

    ITKE435,945 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?

    ITKE435,945 pointsBadges:
  • Calculate overall sum of SQL Server database sizes

    In my SQL Server, I need to find out how much space my databases are using. I tried using sys.databases but it's giving me separate results and I have to put that into Microsoft Excel and do the math there. Can I do this using T-SQL? Thanks so much.

    ITKE435,945 pointsBadges:
  • 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.

    ITKE435,945 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?

    ITKE435,945 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?

    ITKE435,945 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?

    ITKE435,945 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?

    ITKE435,945 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.

    ITKE435,945 pointsBadges:
  • Query database sizes in SQL Server 2008 R2

    I'm using SQL Server 2008 R2 that has over 500 databases. What would be the easiest and most efficient way to query databases of all sizes. The output should have the following columns:DatabaseNameDataFilesSizeLogFilesSizeThanks for all the help!

    ITKE435,945 pointsBadges:
  • How to script entire SQL Server database

    Does anyone know if there's a possible way to get a script of an entire SQL Server database? I'm taking about columns, tables, stored procedures, etc. Thank you.

    ITKE435,945 pointsBadges:
  • Storing passwords in SQL Server database

    What's the best way to store my passwords in a SQL Server database (it's actually for 2008 and 2012)? For the past few years, I've been using a .NET encryption library, followed by storing them in the database. Should I continue with this method or figure something else out?

    ITKE435,945 pointsBadges:
  • SQL Server: Insert number of rows into a table

    I have a SQL Server database where I currently upload files into a staging table. On the table, I have 2 JOINs that corrects foreign keys. That's followed by putting these rows into one final table. Right now, there's roughly over 3 billion rows of data. Now here's my question: What's the best (or...

    ITKE435,945 pointsBadges:
  • How to fix a SQL Server database that’s stuck in a restoring state

    Our department currently has a SharePoint server. But our network administrator mis-configured the backup tool (it was Symantec Backup Exec) and several of our SQL Server databases are stuck in restoring state. What should we do? Can we get these databases back?

    ITKE435,945 pointsBadges:
  • How to tell if my SQL Server database is still in use

    We have to get rid of a SQL Server instance (basically decommission it) but it still has several databases left on it. Is there a way to tell if these databases are still being used by our users? Thank you very much.

    ITKE435,945 pointsBadges:
  • How to use SQL Server 2005

    I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.

    Anand79865 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