Richard Teachout - My technobabble Blog

Search this Blog

KeywordsPhrase

Links I like to keep around

Here are the most recent postings to this blog. Use the archive calendar or search to find other entries.

Author:	R Teachout	Created:	6/15/1999 6:20 AM
Just some stuff I find or create that may be useful later.

MSSQL: Single User Mode on Database

By R Teachout on 12/28/2006 1:07 PM

EXEC sp_dboption 'db_name, 'single user', 'FALSE'

Comments (0)

MSSQL: Change DBO

By R Teachout on 12/23/2006 2:18 PM

use dbname execute sp_changedbowner [user]

Comments (0)

SQL: Use SQL to schedule backups

By R Teachout on 12/11/2006 12:00 PM

Copy / synchronize directories / folders

Comments (0)

Running 2000->2005 SQL Upgrade

By R Teachout on 12/4/2006 3:11 AM

Ran upgrade, got the error: Cannot find folder "\Maintenance Plans". Here's how to fix it.

Comments (0)

SQL: Search / Set Recovery Model on All Databases

By R Teachout on 12/1/2006 9:18 AM

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.sqlUPLOADTEMPLATE

Comments (0)

SQL:Determine MSSQL Database + DBLog Used + Allocated Size

By R Teachout on 11/18/2006 8:23 PM

Ever wondered what is still available & whether or not you needed to dump your log to make space?

Comments (0)

SQL:Dump Transaction log + free space

By R Teachout on 11/18/2006 7:21 PM

MSSQL Database

Comments (1)

If a problem can be solved, there's no use worrying about it. If it can't be solved, worrying will do no good.
-Unknown