none
who is Connected to my server RRS feed

  • Question

  • how can I query who is connected to my sql server 2005?

    please help.
    thanks in advance
    Tuesday, March 16, 2010 3:54 AM

Answers

  • Try

    execute sp_who
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Proposed as answer by SA_Green Tuesday, March 16, 2010 4:02 AM
    • Marked as answer by Select-Help Thursday, March 18, 2010 1:46 AM
    Tuesday, March 16, 2010 4:00 AM
    Moderator
  • sp_who 'active'
    

    family as water
    • Marked as answer by Select-Help Thursday, March 18, 2010 1:46 AM
    Tuesday, March 16, 2010 4:18 AM

All replies

  • Try

    execute sp_who
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    • Proposed as answer by SA_Green Tuesday, March 16, 2010 4:02 AM
    • Marked as answer by Select-Help Thursday, March 18, 2010 1:46 AM
    Tuesday, March 16, 2010 4:00 AM
    Moderator
  • sp_who 'active'
    

    family as water
    • Marked as answer by Select-Help Thursday, March 18, 2010 1:46 AM
    Tuesday, March 16, 2010 4:18 AM