August 13, 2007 at 9:25 am
When I am logged into some server as myself, in the user database, If I run the sql query pasted below, I get the error “Ther user does not have permission to perform this action”. How to give access to dmv apart from the user who don't have admin access?
select * from sys.dm_broker_activated_tasks
August 13, 2007 at 9:57 am
A member of sysadmin must grant you VIEW SERVER STATE permission for you to select from the view.
Greg
Greg
August 13, 2007 at 10:01 am
Please help me how to use view server state permssion. It will be thankfull if u give the exact query.
August 13, 2007 at 10:27 am
Thanks Greg. it is working now.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply