---
title: "DBCC TRACESTATUS (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "07/17/2017"
ms.prod: "sql-non-specified"
ms.prod_service: "sql-database"
ms.service: ""
ms.component: "t-sql|database-console-commands"
ms.reviewer: ""
ms.suite: "sql"
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
f1_keywords: 
  - "DBCC_TRACESTATUS_TSQL"
  - "DBCC TRACESTATUS"
  - "TRACESTATUS_TSQL"
  - "TRACESTATUS"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "global trace flags [SQL Server]"
  - "status information [SQL Server], trace flags"
  - "trace flags [SQL Server], status information"
  - "DBCC TRACESTATUS statement"
  - "session trace flags [SQL Server]"
  - "displaying trace flag status"
ms.assetid: 9be51199-78b4-4b87-ae6e-557246b7e29a
caps.latest.revision: 36
author: "barbkess" 
ms.author: "barbkess"
manager: "craigg"
ms.workload: "On Demand"
---
# DBCC TRACESTATUS (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

Displays the status of trace flags.
  
![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
  
## Syntax  
  
```sql
DBCC TRACESTATUS ( [ [ trace# [ ,...n ] ] [ , ] [ -1 ] ] )   
[ WITH NO_INFOMSGS ]  
```  
  
## Arguments  
*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.
  
## Result Sets  
The following table describes the information in the result set.
  
|Column name|Description|  
|---|---|
|**TraceFlag**|Name of trace flag|  
|**Status**|Indicates whether the trace flag is set ON of OFF, either globally or for the session.<br /><br /> 1 = ON<br /><br /> 0 = OFF|  
|**Global**|Indicates whether the trace flag is set globally<br /><br /> 1 = True<br /><br /> 0 = False|  
|**Session**|Indicates whether the trace flag is set for the session<br /><br /> 1 = True<br /><br /> 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.
  
## Remarks  
In [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)], 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.
  
## Permissions  
Requires membership in the **public** role.
  
## Examples  
The following example displays the status of all trace flags that are currently enabled globally.
  
```sql  
DBCC TRACESTATUS(-1);  
GO  
```  
  
The following example displays the status of trace flags `2528` and `3205`.
  
```sql  
DBCC TRACESTATUS (2528, 3205);  
GO  
```  
  
The following example displays whether trace flag `3205` is enabled globally.
  
```sql  
DBCC TRACESTATUS (3205, -1);  
GO  
```  
  
The following example lists all the trace flags that are enabled for the current session.
  
```sql  
DBCC TRACESTATUS();  
GO  
```  
  
## See Also  
[DBCC &#40;Transact-SQL&#41;](../../t-sql/database-console-commands/dbcc-transact-sql.md)  
[DBCC TRACEOFF &#40;Transact-SQL&#41;](../../t-sql/database-console-commands/dbcc-traceoff-transact-sql.md)  
[DBCC TRACEON &#40;Transact-SQL&#41;](../../t-sql/database-console-commands/dbcc-traceon-transact-sql.md)  
[Trace Flags &#40;Transact-SQL&#41;](../../t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql.md)