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

CHECKDB

Finding and listing all columns in a database with default values

I was troubleshooting an issue last week on a vendor-developed database when they stated we needed to look at each one of the 50 tables in their database to make sure that all fields expecting default values, had default values assigned.

Options for scripting database objects

SQL Server Management Studio is rich with features. So rich, in fact, that after almost 3 years I am still finding new tools in the application that afford me more control over my databases and the methods for supporting them. Recently I found myself needing to script out a database and its objects for reviewing a problem offline.