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.
0 comments:
Post a Comment