sp_trace_setstatus | Varinder Sandhu

SQL Server – Stop/Close a Server-Side Trace

Varinder Sandhu SQL, SQL-Advanced, SQL-Performance, SQL-Tips and Tricks, Varinder Sandhu

This function “sp_trace_setstatus” modifies the current state of the specified trace. Syntax sp_trace_setstatus [ @traceid = ] trace_id , [ @status = ] status Example –See the Ruuning trace SELECT * FROM ::fn_trace_getinfo(NULL) — Stop thr Running Trace EXEC sp_trace_setstatus @traceid = 1 , @status = 0 — Delete the Running trace EXEC sp_trace_setstatus @traceid = 1 , @status = 2 Note: 0 = Stops the specified trace. 1 = Starts the specified trace. 2 = Closes the specified trace

» Read more

Server Side Trace, sp_trace_setstatus, SQL Server