Locate primary key - foreign key relations

Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]

Delete files older than n-days via T-SQL

Delete files on a fileshare leaving behind files not older than n-days.

Detach and Reattach all user databases

Database server migration or SQL Server up gradation

Backup Stored Proc

Script to backup 2000/2005 databases.

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.

Generate Scripts to Compare Tables

Generate the scripts that will allow you to compare tables pass/fail.

Troubleshooting Service Broker (SSB)

Troubleshooting Service Broker (SSB)

Copy One Schema to Another Schema

This script copies one object in another multiple schema.

List all tables without LOB columns

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).

Useful when rebuilding indexes online.

Detach All User Databases

Detach all user databases on a SQL 2008 instance