hi, we've implemented this on our sql server and it's working a treat, however, I've become greedy and also want to get the objectid of the object that is being traced (in particular DTS Designer

and SQLAgent - Job Manager, i've tried adding the following line into the stored procedure for each Trace Event block...

exec sp_trace_setevent @traceident, XX, 22, @on

however nothing is returned. I'm not an sql guru so it may be something really fundamental that I'm not understanding, can you help?