sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?

Email SP Results

Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.

Recent Restore History

This script simply returns the most recent restore information about databases for a server.

Returns the destination database name, the device used to perform the restore and the restore date.

Disk Capacities

Provides information on the total and used space for all drives on an instance.

Database Growth History

This script uses the backup tables to get info on the growth of your database files.