Activity Monitor

• dwjongbloed

  SSC Eights!

  Points: 943

  More actions

  January 21, 2010 at 1:35 pm

  #229275

  I have a developer that is wanting to be able to use Activity Monitor in SQL2005. The only way that I have found to be able to do this is to grant him SYSADMIN access and I AM NOT going to do that. Does anyone have any other ideas as to how to grant someone access to be able to use Activity Monitory without granting SYSADMIN access? I tried using sp_who2 but that only shows results for the particular user unless you have SYSADMIN access.

  Any and all help on this matter will be greatly appreciated.

• SQLPirate

  SSCrazy

  Points: 2880

  More actions

  January 21, 2010 at 3:18 pm

  #1106987

  GRANT VIEW SERVER STATE TO username

  Or through SSMS:

  Under security > logins for the server, right click on the SQL Login and select properties.

  Select the Securables page.

  Click Add... and select the option for "The server 'SERVERNAME'" and click OK

  Scroll to the bottom of the list and you'll find View Server State options