Post reply

current sessions in database

  • December 25, 2008 at 5:02 am

    #94622

    hi,

    How do find current sessions in database access through sql server 2000? not in sql profiler.

    thanks.

  • December 25, 2008 at 8:06 am

    #917631

    do you mean something other than using sp_who or sp_who2?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 25, 2008 at 10:27 am

    #917651

    sp_who2 works just fine for finding sessions. u can also query sysprocesses table.


    Pradeep Singh

Viewing 3 posts - 1 through 2 (of 2 total)

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