Logon Trigger for SQL TRACING

Dear Pete ,

Thanks.

I looked at your paper about SQL tracing. It contains great information about SQL TRACING.
The Logon trigger that you use for enable sql tracing is a good approach.
With regards to this, should we further enhance this Logon trigger for enabling SQL TRACE for a particular session? Because I wanted to pass a name or sid, serial# on run time to this Logon trigger/procedure for enabling SQL TRACING for a specific user not for many users.
Is that possible? If so could you give advice about how to do that?

Thanks

Bill Received on Wed Mar 10 2004 - 04:27:35 CST