a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.  Read more...

Query to save all index metadata  Read more...

The Store Procedure can be use for generating Differential Backup datewise in SQL Server 2000.  Read more...

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...

Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.  Read more...

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.  Read more...

This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.  Read more...

If you ever need a quick way to generate random passwords, this is a pretty useful way to do so.  Read more...

Scripts permissions/roles for db user across all databases.  Read more...

This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL  Read more...

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.  Read more...

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.  Read more...

Feed it delimited horizontal data and it returns it back as a vertical table.  Read more...

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2000  Read more...

Creates statements for securables creation.  Read more...

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.  Read more...

A stored procedure that generates sql to determine the difference for each record and field.   Read more...

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).   Read more...