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 »
Read 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 »
