December 11, 2014 at 3:02 am
Hi All,
If I want to give the access the Profiler to a new login what Permission do i have to give?
Regards
Chowdary...
December 11, 2014 at 3:42 am
ALTER TRACE
And tell them to never use the Profiler GUI against a production server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 11, 2014 at 4:04 am
Thank you Gail Shaw....
Regards
Chowdary...
December 11, 2014 at 8:20 am
Don't do it.
Instead, give them permissions to create extended events[/url]. It's much more lightweight and much less fear of bringing down a production system.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply