Post reply

to run sp_who2

  • March 7, 2012 at 2:45 pm

    #254370

    A developer needs sometimes to check if users are connected to databases using sp_who2, if not, then they can deploy their application code.

    So he is asking me to grant him to run sp_who2 to see who is connected to his production database.

    He currently is the dbo of the database, what else permisson I can grant her to run sp_who2?

    Thanks

  • March 7, 2012 at 3:03 pm

    #1456282

    to see all users, you need to grant view server state permissions.

    grant VIEW SERVER STATE to TheRightRole;

    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!

  • March 7, 2012 at 4:04 pm

    #1456312

    Thanks

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

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