Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

How to: Delete a Trace (Transact-SQL)

This topic describes how to use stored procedures to delete a trace.

  1. Execute sp_trace_setstatus by specifying @status = 0 to stop the trace.

  2. Execute sp_trace_setstatus by specifying @status = 2 to close the trace and delete its information from the server.

ms189898.note(en-US,SQL.90).gifNote:
A trace must be stopped first before it can be closed.

Community Additions

ADD
Show:
© 2015 Microsoft