 

Use Master;  -- Master database because mastr has all login configurations

 

GRANT VIEW SERVER STATE TO [Domain\UserName]; --Change the username and domain Ex : [SPARTA\krishna];

 

GRANT SHOWPLAN TO [Domain\UserName]; --Change the username and domain Ex : [SPARTA\krishna];

 

GRANT ALTER TRACE TO [Domain\UserName]; --Change the username and domain Ex : [SPARTA\krishna];

 
