• 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!

    ITKE409,390 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.

    ITKE409,390 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?

    ITKE409,390 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...

    ITKE409,390 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?

    ITKE409,390 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.

    ITKE409,390 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:
  • SQL Server: Should I have auto-shrink turned on?

    This is a basic SQL Server question, but for my database, should I use the auto-shrink option. But someone told me it's not really secure. Is that true?

    ITKE409,390 pointsBadges:
  • Can I add a dependency to a Windows Service?

    We currently have a Windows Service that's using a SQL Server database. I don't have control over it (my boss does) but he asked me to add a dependency so it starts up after SQL Server starts up. Can I do this? Is there a specific tool I have to use?

    ITKE409,390 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 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:
  • Problem with SQL Server Database File(.mdf)

    I am using SQL Server 2008 R2 and I want to check my master database file (.mdf) but failed to open it.

    edwinjhoffer3,205 pointsBadges:
  • 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 do I convert a text file into SQL server database table using Visual Basic 6.0?

    Can anyone tell me how do I convert a text file into SQL server database table using Visual Basic 6.0?

    Iaquinto5 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    Does anyone have a project plan for Access 2007 database migration to SQL Server?

    Anflores5 pointsBadges:
  • What type of Raid to use on Windows Servers and tempdbs?

    I have a SQL Server with eight disks, and I am not sure if I should use Raid 10 twice, one for Windows Server 2003 with NDFs and the other for the log file and tempdb, or apply Raid 1 for the Windows Server, Raid 10 for the NDF and MDF, and Raid 1 again for the tempdb and log. What would you...

    SQL Server Ask the Experts2,585 pointsBadges:
  • I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • Porting MS Access database to SQL Server

    I've got a problem with porting my MS Access database to SQL Server. In my inventory database, I have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, I do with this kind of queries: a....

    Ipong40 pointsBadges:
  • Restoring SQL databases

    Sir, I have deleted a table in SQL database. Is there any option to recover it without losing the data. Please reply.

    H1005 pointsBadges:
  • Transferring a database from Microsoft Access to SQL Server 2000

    How would I transfer a database from Microsoft Access to SQL Server 2000?

    SQL Server Ask the Experts2,585 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