Jason,

I have used this to great effect! However, rather than use it as a stored proc, I just run the query to get the information.

I'm sure you're asking why. Mainly because I support many databases that I am not the direct DBA for. If I am troubleshooting, this is one of the tools in my toolbox.

Recently I have been getting errors and it took me a while to figure out just what the heck I did. Basically, if you run this script against any database other than Master, it fails with all manner of nifty errors :pinch:

I just added "USE Master" at the top so that I don't make that mistake again.

In anycase, thanks a ton for this handy tool!!