• Nice article Eli and has certainly generated some discussion.

    I too would use OPENROWSET in a derived table, rather than creating the view etc. if I was trying to achieve the same aim with system stored procedures in SQL 2000, but anything that generates four pages of forum posts is good stuff! We only learn from discussions such as this and, if no one has the bottle to put up something to discuss, no one learns!

    In 2005+ i would use the DMVs.

    Keep on writing.

    James

    James
    MCM [@TheSQLPimp]