Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.

Kill SPIDs through automated job(while restore)

Here's a script, for killing a SPIDs against a particular database, here am using BIN as the database.

Bread and Butter of SQL Server DBA - Part 1

We have a new author at SQLServerCentral.com, Muthusamy Anantha Kumar AKA The MAK, who starts a new series on the basics that a DBA needs to know. This installment walks over basic backup and restore.

Find Largest size Tables in a Database

To find a list of Tables (User or System tables)according to their size.

udf_is_database_available

function which checks a database on availability

Find all objects in Server Owned by a Login

Find every object in every database owned by a particular Login.

SQL 2005 HTML Job Report

Get a report of all your SQL jobs in HTML Format

Moving Files

Return Query Text Along With sp_who2 Using Dynamic Management Views

This article describes how to generate the sp_who2 results including the query text for the spid.

Cloning