sql 2005

Ho to grant access to  a developer to run sql profiler (sql2005)?  
what type of access he has to have on the SQL ?

Thanx
chetan
MuraliPitaniAsked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Commented:
You're right ... in SQL 2005, there's a more granular way:
GRANT ALTER TRACE TO John
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1127863,00.html
btw, anything Adam Machanic writes is worth reading!
0
 
Daniel WilsonCommented:
sysadmin

But ... supposedly there's another way.  Have not tested it myself:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47384
0
 
MuraliPitaniAuthor Commented:
it shouldnt be sysadmin as far as i remember.. thats a case in sql 2000
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.