Good point and true. I was just posting this quickly to share. I really didn't have the time for much more and certainly not to elaborate to that extent. If...

Sorry for the late reply. Been in the middle of a data center move and well...you know how that can be.

Thank you for your responses. I think you kinda missed...

Geesh...you guys beat me to it!

if exists

(

select OBJECT_NAME(o.id) as tempdbname, * from tempdb.dbo.sysobjects o

where o.xtype in ('U')

...

No it most certainly will not failover automatically.

This is awesome. I made one small change that others may find useful. Preceding the order by statement, I added the following where clause line to filter out the sp_who3...

This is awesome except for one thing....

It seems that databases with a dash "-" in the name are being truncated. The name is selected in to @dbname but when it...