• How to view content damaged MS SQL Server database?

    Help! Dead computer and all the information. Computer to reinstall formatting (otherwise failed). With the help of programs to restore files managed to pull Fail SQL database (.mdf). But on the other computer does not accept the file. Writes an error. Already tried everything. How do I restore the...

    hanamor11005 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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.

    ITKE828,145 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.

    ITKE828,145 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.

    ITKE828,145 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.

    ITKE828,145 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.

    ITKE828,145 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?

    ITKE828,145 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.

    ITKE828,145 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.

    ITKE828,145 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?

    ITKE828,145 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?

    ITKE828,145 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?

    ITKE828,145 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?

    ITKE828,145 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.

    ITKE828,145 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!

    ITKE828,145 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.

    ITKE828,145 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?

    ITKE828,145 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...

    ITKE828,145 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?

    ITKE828,145 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