sp_trace_setstatus (Transact-SQL)

[ @traceid = ] trace_id

Is the ID of the trace to be modified. trace_id is int, with no default. The user employs this trace_id value to identify, modify, and control the trace. For information about retrieving the trace_id, see fn_trace_getinfo (Transact-SQL).

[ @status = ] status

Specifies the action to implement on the trace. status is int, with no default.

The following table lists the status that may be specified.

Status	Description
0	Stops the specified trace.
1	Starts the specified trace.
2	Closes the specified trace and deletes its definition from the server.

Note:
A trace must be stopped first before it can be closed. A trace must be stopped and closed first before it can be viewed.

The following table describes the code values that users may get following completion of the stored procedure.

If the trace is already in the state specified, SQL Server will return 0.

Parameters of all SQL Trace stored procedures (sp_trace_xx) are strictly typed. If these parameters are not called with the correct input parameter data types, as specified in the argument description, the stored procedure will return an error.

User must have ALTER TRACE permission.

Reference

Other Resources

Help and Information