Get Modified Objects As on Date

This table Valued Function return the Modified Objects (SP /Views) For the Date specified.

Create Insert for Existing Rows

Will print the insert statements needed to recreate a table.

Using sys.dm_exec_requests to estimate completion time for a process

The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.

Generating number sequences with Common Table Expressions

The script shows one of ways generating number sequence - this one uses CTE.

URLEncode

Here is a short UDF to URL encode a string. Requires a numbers table.

Copy Multiple objects from One Schema to Another Schema

Copy Multiple objects from One Schema to Another Schema

Function to Expand Tab Characters

A function to replace tab characters with the correct number of spaces to align the text as originally intended.

Verify Last successful CHECKDB on all databases

Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance.

Does not work on SQL 2000.

Find all objects in Server Owned by a Login

Find every object in every database owned by a particular Login.

Schema comparison

Compares table layouts between a source and target database.