Post reply

Logged Users

  • June 18, 2007 at 7:53 am

    #68580

    Many times i need to see which users are currently logged to my server. Is there a easy way i could track this information quicky.

    Thanks in advance.

  • June 18, 2007 at 9:19 am

    #713582

    You can use sp_who stored procedure to return the details required.

    Thanks

     


    Lucky

  • June 18, 2007 at 9:56 am

    #713595

    But that lists out everything including sleeped users. I am more interested to know what are the users that are currently actively connected to my server.

  • June 18, 2007 at 2:15 pm

    #713650

    You can select whatever need from sp_who2 and filter the sleeping in where cluase. Create another SP

    Nita

  • June 18, 2007 at 4:19 pm

    #713675

    I use Management-> Current Activity window Processes view in 2000 and Management -> Activity Monitor in 2005 to find out who is connected and sort by Last Batch field.

    Regards,Yelena Varsha

  • June 18, 2007 at 10:52 pm

    #713722

    sp_who2 active will list only the active users. you can use this.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 19, 2007 at 11:04 am

    #713909

    sp_who active works as well

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • June 19, 2007 at 10:32 pm

    #713999

    I prefer to write my own queries off of sysprocesses.  If you have lots of users, applications, or databases, filtering things out in a where clause is the way to go.

    Regards,
    Rubes

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply