Archive for the ‘Profiler’ Category

If you don’t want to give SysAdmin to developers on a test or live server you can apply these permissions:

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];

as per this article:

http://msdn.microsoft.com/en-us/library/ms187611.aspx