Backup Stored Proc

Script to backup 2000/2005 databases.

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.

Generate Scripts to Compare Tables

Generate the scripts that will allow you to compare tables pass/fail.

Short Script to Backup All User Databases

Backup All User Databases with sp_msforeachdb

Troubleshooting Service Broker (SSB)

Troubleshooting Service Broker (SSB)

Getting Age in Text or Date Difference in text format

This function returns the difference between the date in text format

Copy One Schema to Another Schema

This script copies one object in another multiple schema.

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).

Useful when rebuilding indexes online.

Find gaps in primary keys across multiple databases

Output table of gaps in a primary key across multiple databases on same, remote and/or linked servers.

Detach All User Databases

Detach all user databases on a SQL 2008 instance