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.
Just tried this and it doesn't work :(
ReplyDeleteCool!! Worked for me.. :)
ReplyDeleteworked for me
ReplyDelete