Delete a Trace (Transact-SQL)
Applies to: SQL Server
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)
Tagasiside
https://aka.ms/ContentUserFeedback.
Varsti tulekul: 2024. aasta jooksul tühistame GitHubi probleemide funktsiooni sisutagasiside mehhanismina ja asendame selle uue tagasisidesüsteemiga. Lisateabe saamiseks vtEsita ja vaata tagasisidet