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.

Parse the dependency chain of an object

Parses up & down the dependency chain of an object.

Set standard database options

Ensure all your databases have standardised options by running this script weekly.

How to Test Connectivity for a Linked Server

Just one way of testing for a linked server based on data within your database.