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)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Uskoro: tokom 2024. postepeno ćemo ukidati probleme s uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zamijeniti ga novim sistemom povratnih informacija. Za više informacija, pogledajtePošalјite i prikažite povratne informacije za