Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

DBCC TRACESTATUS

SQL Server 2000

Displays the status of trace flags.

Syntax

DBCC TRACESTATUS ( trace# [ ,...n ] )

Arguments

trace#

Is the number of the trace flag whose status will be displayed.

n

Is a placeholder that indicates multiple trace flags can be specified.

Result Sets

DBCC TRACESTATUS returns a column for the trace flag number and a column for the status, indicating whether the trace flag is ON (1) or OFF (0). To get status information for all trace flags currently turned on, specify - 1 for trace#.

Remarks

To enable certain trace flags, use DBCC TRACEON. To disable trace flags, use DBCC TRACEOFF.

Permissions

DBCC TRACESTATUS permissions default to any user.

Examples
A. Display the status of all trace flags currently enabled

This example displays the status of all currently enabled trace flags by specifying a value of -1.

DBCC TRACESTATUS(-1)
GO
B. Display the status of multiple trace flags

This example displays the status of trace flags 2528 and 3205.

DBCC TRACESTATUS (2528, 3205)
GO

See Also

DBCC

DBCC TRACEOFF

DBCC TRACEON

Trace Flags

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.