sys.sp_trace_setstatus

general

#stored-procedure

Description

Modifies the current state of the specified trace. The ID of the trace to be modified. , with no default. The user employs this value to identify, modify, and control the trace. For information about retrieving the This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Syntax

sp_trace_setstatus
[ @traceid = ] traceid
, [ @status = ] status
[ ; ]