A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...

The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user  Read more...

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.  Read more...

A hopefully useful script to delete old files, not just backups, and make use of the archive bit.  Read more...

Used to generate Select/Delete scripts. It does NOT run them. You need to copy the output of this script to a new window and run it manually.   Read more...