I found this script to be useful for sql server 2005 as well.

We do have DMV's for this purpose in 2005. But still nice to have this script.

Well, if we need to run at the instance level rather than database level,

could we have that that too?

Because we have so many databases on the instance.