This procedure generates INSERT statements using existing data from the given tables and views. Later, you can use these INSERT statements to generate the data. It's very useful when you have to ship or package a database application. This procedure also comes in handy when you have to send sample data to your vendor or technical support provider for troubleshooting purposes. Read More »
Read More »
To Load from a Text File into MSSQLRead More »
Closes the current error log file and cycles the error log extension numbers just like a server restart. The new error log contains version and copyright information and a line indicating that the new log has been created. MSSQL.1\MSSQL\LOG\ERRORLOGRead More »
This allows you to set the permissions on all of the stored procedures (except the built-in ones) on a database.. great after a SQL RecoveryRead More »
Pricing for SQL Server 2005 - Retail Pricing, for Reference... this puts the monthly price of MSSQL SPLA into perspective.Read More »
a tool for SQL Server 7.0/2000/2005 database administrators and developers to generate data scripts in a valid T-SQL format which can be executed in Query Analyzer. Read More »
EXEC sp_dboption 'db_name, 'single user', 'FALSE'Read More »
use dbname execute sp_changedbowner [user]Read More »
Copy / synchronize directories / foldersRead More »
Ran upgrade, got the error: Cannot find folder "\Maintenance Plans". Here's how to fix it.Read More »
Have a lot of databases? Use these scripts to change all db's to simple or full, or just to list all recovery modes. list_all_db_recovery_modes.sql set_all_db_recovery_to_full.sql set_all_db_recovery_to_simple.sqlUPLOADTEMPLATERead More »
Ever wondered what is still available & whether or not you needed to dump your log to make space?Read More »
MSSQL DatabaseRead More »
