How to modify an existing trace (Transact-SQL)

To modify an existing trace

1. Execute xp_trace_addnewqueue with the required parameters to create a trace queue.
2. Execute xp_trace_loadqueuedefinition with the required parameters to reload the trace definition.

   ---

   Note Executing xp_trace_loadqueuedefinition performs the same functionality as the xp_trace_seteventclassrequired and xp_trace_set* procedures mentioned in How to create a trace (Transact-SQL).

   ---

3. Optionally, execute the applicable xp_trace_get* extended stored procedures to determine which filters were previously set with the saved trace queue definition.
4. Optionally, execute the applicable xp_trace_set* extended stored procedures to set any, none, or a combination of filters.
5. Optionally, execute xp_trace_setqueuedestination to change the trace queue information destination.
6. Optionally, execute xp_trace_savequeuedefinition to resave the trace definition.

See Also