Home Forums SQL Server 7,2000 In The Enterprise Is There A Way To List Current Activity, Such As Primary Key? RE: Is There A Way To List Current Activity, Such As Primary Key?

  • February 4, 2010 at 8:50 am

    #1113803

    Well, I now know about sp_who.

    The database is our ERP database - "everyone's always in it". :hehe:

    I ran sp_who and there are 87 people in the database. All but one is "sleeping" / "AWAITING COMMAND".

    If everyone's status is sleeping I could do my updates.

    Nice suggestion, it's a start - "Brute force" is how one of my college professors would describe it.

    [font="Verdana"]"The Road To Success Is Always Under Construction."[/font]