1. lcerni New Member

   Is there a way to grant a Developer the use of using SQL Server Profiler without giving him the role of sysadmin?
   

   lcerni, Jan 6, 2009

   #2
2. Luis Martin Moderator

   As far I know, no.BTW: Why developer should run Profiler?. That is DBA job.

   Luis Martin, Jan 6, 2009

   #3
3. lcerni New Member

   We have a third party application that he will be responsible for and he wants to understand better how it is working. The documentation from the 3rd party is thin.
   

   lcerni, Jan 6, 2009

   #4
4. satya Moderator

   Dont know which version of SQL Server you are running, here is the information from BOL:
   In order to run a trace against SQL Server you have to be a member of sysadmin fixed server role or have ALTER TRACE server permission.
   http://msdn.microsoft.com/en-us/library/ms187611.aspx
   http://msdn.microsoft.com/en-us/library/ms187929.aspx
   

   satya, Jan 7, 2009

   #5

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in