Traces and sysadmin

• aureliu

  SSC-Addicted

  Points: 439

  More actions

  March 31, 2004 at 4:50 am

  #161348

  Hi,

  Is possible   to make a trace(template) with sp_create,(included in  a job)and grant the rights for users(not sysadmin) to  rule this trace(or job)?Or how could I solve the problem?

  Thank you,

   Stan Aureliu

• marris

  SSC-Addicted

  Points: 469

  More actions

  April 4, 2004 at 9:00 pm

  #501708

  sp_trace stored procs require sysadmin privilege in SQL 2K. It is a powerful facility and hopefully MS will remove this restriction in Yukon.