Traces and sysadmin

  • 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

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply