By R Teachout on 12/12/2007 6:10 PM
Run a query against sysprocesses to figure out what is going on on a SQL ServerRead More » |
By R Teachout on 9/23/2007 3:31 PM
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)Read More » |
By R Teachout on 9/23/2007 3:20 PM
Search error log for "Return value 3" and trace to find out what you're missing, then install that, then go with it.Read More » |
By R Teachout on 6/13/2007 10:24 PM
Here's a quick how-to (for those technically inclined) on:
How to Get the Current Activity for a Single Database (SQL2000) when running as a DBO not as a sysadminRead More » |
By R Teachout on 6/3/2007 10:07 PM
Great for queries where you need > date < date results..Read More » |
By R Teachout on 5/14/2007 8:16 PM
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 » |
By R Teachout on 5/4/2007 10:08 AM
To Load from a Text File into MSSQLRead More » |
By R Teachout on 4/27/2007 2:39 PM
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 » |
By R Teachout on 3/31/2007 9:32 PM
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 » |
By R Teachout on 3/5/2007 1:19 AM
Pricing for SQL Server 2005 - Retail Pricing, for Reference... this puts the monthly price of MSSQL SPLA into perspective.Read More » |
By R Teachout on 1/31/2007 1:54 AM
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 » |
By R Teachout on 12/28/2006 1:07 PM
EXEC sp_dboption 'db_name, 'single user', 'FALSE'Read More » |
By R Teachout on 12/23/2006 2:18 PM
use dbname
execute sp_changedbowner [user]Read More » |
By R Teachout on 12/11/2006 12:00 PM
Copy / synchronize directories / foldersRead More » |
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.Read More » |
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.sqlUPLOADTEMPLATERead More » |
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?Read More » |
By R Teachout on 11/18/2006 7:21 PM
MSSQL DatabaseRead More » |