This script automatically starts a trace and stores the trace data in to a table and then analyzes the data and generates a report on worst performing queries.

--Check current owners
SELECT name, description, suser_sname(ownersid)
FROM msdb.dbo.sysdtspackages90

--Change Maintenance Plan ownership
UPDATE msdb.dbo.sysdtspackages90
SET OWNERSID = SUSER_SID('sa')
WHERE OWNERSID = SUSER_SID('login')

Script to identify databases that have no full or transaction log backups, either today or yesterday. It reads from the MSDB tables and excludes Model and TempDB. Will only display, if a database fits the criteria.

Generates a detailed SQL login permissions report.  Compatible with SQL2000 and up.  Please see the beginning of the script for the legend: dr dw dbo etc.

This script will allow you to find out which object (table or index or heap) in which filegroup/file.    This could be very useful when emptying filegroup and you don't know which object is still using that filegroup.