Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This topic describes how to use stored procedures to delete a trace.
For an example of using trace stored procedures, see Create a Trace (Transact-SQL).
To delete a trace
Execute sp_trace_setstatus by specifying @status = 0 to stop the trace.
Execute sp_trace_setstatus by specifying @status = 2 to close the trace and delete its information from the server.
Note
A trace must be stopped first before it can be closed.
See Also
sp_trace_setstatus (Transact-SQL)
System Stored Procedures (Transact-SQL)
SQL Server Profiler Stored Procedures (Transact-SQL)