move MDF or LDF files to new location

This stored procedure move the LDF or MDF to a new location.

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).

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