In Order to run a trace against SQL Server you must be a member of sysadmin. (Enable trace access without granting sysadmin role)

Monday, August 18, 2014

Use below query to enable trace access without granting sysadmin role.


Use Master;
GRANT VIEW SERVER STATE TO [Domain\ADGroup or User];
GRANT SHOWPLAN TO [Domain\ADGroup or User];
GRANT ALTER TRACE TO [Domain\ADGroup or User];




Checkout Deal of the Day on Amazon.
Related Posts Plugin for WordPress, Blogger...

0 comments:

Post a Comment

 
© Copyright 2010-2012 Learn MySQL All Rights Reserved.
Template powered by Blogger.com.