Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 role name

Author  Topic 

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2013-05-09 : 13:12:38
Hi,

What role to be enabled for running sql server profiler?.
Any help be appreciated..

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2013-05-09 : 13:33:17
sysadmin is the only role I know of that, by default, can run Profiler. What you can do is GRANT ALTER TRACE rights to a user.

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
Go to Top of Page

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2013-05-09 : 13:50:29
Thanks Bustaz Kool
quote:
Originally posted by Bustaz Kool

sysadmin is the only role I know of that, by default, can run Profiler. What you can do is GRANT ALTER TRACE rights to a user.

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber

Go to Top of Page

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2013-05-09 : 20:24:07
Mi gusto!

=================================================
There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber
Go to Top of Page
   

- Advertisement -