Thank You . I am getting same error. but time being i am solved to change the server STATE . but i will do that certificate .
Any Problem in SERVER STATE changes?
With this permission it is possible for users to run resource-intense DMFs which could negatively impact server performance, e.g.
FROM sys.dm_db_index_physical_stats(NULL, NULL, NULL, NULL, 'detailed');
So, think carefully before granting this permission to all users.
One more thing i am new DBA in my concern.I want your mail id . if i will face any problem like this i will ask clarification . My mail id is firstname.lastname@example.org.
Feel free to send me a Personal Message using the PM link in my posts. If I have time, I will try to answer your queries, but I think you will have a much broader audience if you continued to post questions in the appropriate forums on this site. If you are looking for assistance with specific project work also feel free to send me a PM, and we can work out a fair rate.
Once again Thank You
You're welcome :-)
__________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato