• IT would not be difficult to use SQL-DMO to iterate throught each of the instances and run sp_who  or sp_who2 then display ther results on a web page or in an application.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question