• It won't work in SQL 2000. The query uses Dynamic Management Views which were only introduced in SQL Server 2005.

    Excellent article that I'm sure will come in handy at some point. Thanks for sharing.