January 21, 2010 at 1:35 pm
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.
January 21, 2010 at 3:18 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply