EXEC sp_dboption 'db_name, 'single user', 'FALSE'Read More »
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 »
