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.

Generate Create All Secondary Indexes For Entire Database

Generate Script to create all secondary indexes for a database. I have included the ability to generate online indexes if possible and the ability to move to another file group.

Check Full Recovery DBs Have Tran Log Backups

A quick procedure to check which full recovery databases have not had a tran log backup in the given period (default is 7 days). This could mean that the recovery mode might need changing or the transaction log backup jobs need investigating.

Calculating the Number of Business Hours Passed Since a Point of Time

A set of user defined functions used to calculate the number of business or working hours (excluding the non working hours) that have passed since a certain point of time.