Post reply

Details of users connected to my database

  • March 9, 2011 at 3:43 am

    #233696

    Is it possible for me to check the number of users ( other necessary details ) connected to my database .

    We are just dbo owners of that database and have access only to the query analyser of that database .

    sp_who2 / sp_who3 commands are not working for me 🙁 🙁

    P.S.- Please provide query that will solve the purpose .

  • March 9, 2011 at 3:57 am

    #1296399

    Can you try

    select * from sysprocesses

    M&M

  • March 9, 2011 at 5:03 am

    #1296413

    Even that is not working for us .

    Like sp_who2 - it is showing only our connection , where there are other connections also present .

  • March 9, 2011 at 11:54 pm

    #1296906

    You need VIEW SERVER STATE permission on the server to run commands like sp_who2 etc.

    M&M

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

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