How to modify data columns (Transact-SQL)

To modify data columns (shown in the trace output)

1. If the trace is already running, execute xp_trace_savequeuedefinition to save the trace definition.
2. If the trace is already running, execute xp_trace_destroyqueue with the required parameters to stop the trace.
3. Execute xp_trace_addnewqueue with the required parameters to create a trace queue. In the fifth parameter, list the integer masks for the data columns to be shown in the trace output.
4. Execute xp_trace_loadqueuedefinition with the required parameters to reload the trace definition.

Note The data columns shown in the trace output are not saved in the queue definition. The data columns to be shown must be specified when the trace.

See Also