How to delete a trace (Transact-SQL)

To destroy the trace queue

• Execute xp_trace_destroyqueue to destroy the trace queue without deleting the queue definition.

To delete the trace queue definition

• Execute xp_trace_deletequeuedefinition to delete the named trace queue from the registry.

See Also