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:

get users across all databases on the SQL Server instance

Quick way to get all users on all Databases

Report failed SSRS subscriptions

Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.

Search for a Column in all databases

This Script can be used for searching a column in SQL server 2005

Search for a Table in all databases

This Script can be used for searching a Table in SQL server 2005

Compare SQL code of 2 objects.

Compare SQL code of sp, functions, or triggers. Can run across DB and/or servers. Generates report similar to windif. See details in comments