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:

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

A set based T-SQL Solution for Sudoku Puzzle

A set based T-SQL solution for Sudoku puzzle. This is an update to my previous post with some corrections and in-line comments.

Get DDL for any SQL 2000 table

a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.

Updating Datbase Mail Exchange Server

Problem: We are replaceing our exchange server with a new one all DBMAILs on all server use the old one