• you mean something like sp_who2

    ----------
    Ashish