DBCC TRACESTATUS (Transact-SQL)

DBCC TRACESTATUS (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Displays the status of trace flags.

Topic link icon Transact-SQL Syntax Conventions

  
DBCC TRACESTATUS ( [ [ trace# [ ,...n ] ] [ , ] [ -1 ] ] )   
[ WITH NO_INFOMSGS ]  

trace#
Is the number of the trace flag for which the status is displayed. If trace#, and -1 are not specified, all trace flags that are enabled for the session are displayed.

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

-1
Displays the status of trace flags that are enabled globally. If -1 is specified without trace#, all the global trace flags that are enabled are displayed.

WITH NO_INFOMSGS
Suppresses all informational messages that have severity levels from 0 through 10.

The following table describes the information in the result set.

Column nameDescription
TraceFlagName of trace flag
StatusIndicates whether the trace flag is set ON of OFF, either globally or for the session.

1 = ON

0 = OFF
GlobalIndicates whether the trace flag is set globally

1 = True

0 = False
SessionIndicates whether the trace flag is set for the session

1 = True

0 = False

DBCC TRACESTATUS returns a column for the trace flag number and a column for the status. This indicates whether the trace flag is ON (1) or OFF (0). The column heading for the trace flag number is either Global Trace Flag or Session Trace Flag, depending on whether you are checking the status for a global or a session trace flag.

In SQL Server, there are two types of trace flags: session and global. Session trace flags are active for a connection and are visible only for that connection. Global trace flags are set at the server level and are visible to every connection on the server.

Requires membership in the public role.

The following example displays the status of all trace flags that are currently enabled globally.

DBCC TRACESTATUS(-1);  
GO  

The following example displays the status of trace flags 2528 and 3205.

DBCC TRACESTATUS (2528, 3205);  
GO  

The following example displays whether trace flag 3205 is enabled globally.

DBCC TRACESTATUS (3205, -1);  
GO  

The following example lists all the trace flags that are enabled for the current session.

DBCC TRACESTATUS();  
GO  

DBCC (Transact-SQL)
DBCC TRACEOFF (Transact-SQL)
DBCC TRACEON (Transact-SQL)
Trace Flags (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft