2 Handy SQL Scripts
ALTER DATABASE YourDatabaseName
SET OFFLINE WITH ROLLBACK IMMEDIATE
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
dbid > 0
The Tool that is love is SP_Blitz
Do need to do some SQL Maintenance, i have for you some handy URLs:
Microsoft released SQL Server 2008 R2 to manufacturing (RTM). To promote this new version they have released a free ebook: Introducing Microsoft SQL Server 2008 R2.
To download the ebook just click on the picture.