Friday, March 30, 2012

Grant access to view Activity monitor.


One of my users sent me request to grant her access to view activity monitor in SQL server 2008 R2

This is  a very easy task to do.

USE MASTER
GO
GRANT VIEW SERVER STATE TO myuser
GO

Another way to do that is to right click on the server, locate properties, locate permission and find the user. After selecting the user look at the bottom pane. Find View server State permission and click on it. OK.