This proc will capture a snapshot of all the connections to your SQL Server at the time that it runs. Execute this as a job when an alert fires, and you'll have the user connection context for when something went wrong on your server. (Suggested job and alert creation are included in the script.) Two versions provided- one that includes the last command each connection ran, and one that doesn't.
Stored procedure for SQL Server 2012 that finds and automatically rebuilds indexes fragmented beyond a percentage that you supply as a parameter. The parameterized SSRS 2012 report lets you request the rebuild history by date.
Have your SQL Server figure out which tables & indexes need to be defragmented the most, and then take care of them for you. (For SQL Server 2005 & 2008.)
Included is an SSRS 2008 report to display a history of everything the proc did.
Schedule this stored proc regularly to log the history of your database(s') size, then use the included SSRS 2008 dashboard report to quickly track the growth of your data and log files, or see a snapshot of all your current databases' sizes. (2012 report coming soon.)
Create an automatically-updated log that stores a history of all new, changed, and dropped objects on your database.The download includes an SSRS 2008 report listing all DDL activity between dates you specify.
Quickly list all objects in your database and their permissions, with parameters to select object type, object, or permission to summarize. Includes an SSRS 2008 report letting you choose those parameters interactively.