SQL 2000 datafile locations

This script pulls all data and log files associated with user db's

Nth occurrence of a weekday in a month and year

To find date at nth occurrence of a weekday in a month and year

Backups daily monitoring

This script finds the last run status for Full / TL backups.

Move one Filegroup to another

This script copies all tables found in a specific filegroup to another specific filegroup.

Find all Procedures, Views, Functions that have been renamed

Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.

BCP Format File Builder

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.

Sending SMTP email from SQL Server using CDO

If you would like to send email from SQL Server, use this CDO method and store proceudre.

Automatic Generation of Insert, Update and Delete stored procedures

This script automatically generates stored procedures for insert, update and delete operations on the given table

Backup Both Full and TLog Database Backup within a single Job

This script is basically used in SQL Server 2005/2008 as that version not having the option to perform the same activity in the single window.

Extract Objects of a Linked Server

In a scenario where we need to find out all the objects of a LINKED Server and check which object is accessible to us,

we need to write following query: