will create jobs script for backup or DR purposes to install on another server.  Read more...

Script to check status of active transactions.  Read more...

To merge data in SQL 2005 from various table, we do not have a MERGE function as in SQL 2008. The following script gives an alternative approach of implementing in SQL 2005  Read more...

This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.  Read more...

Procedure tries to kill all connections to the specified database.  Read more...

Find data difference between two datasets  Read more...

I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.  Read more...

This script shows you code that retrives schema of a routine (Stored procedure or a function).   Read more...

Count Number of Words and Characters  Read more...

At times, we have situation to parse the character separated string in the table column.   Read more...

workaround the bug in msdb..sp_get_schedule_description  Read more...

Use this script to search for SQL Server logins who use weak password  Read more...

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.   Read more...

It's a scripts about working with Flat Files  Read more...

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...

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

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

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

returns CREATE TABLE script for any table. including schema name,calculated columns, indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.  Read more...