dbcc-traceoff-transact-sql.md

title	DBCC TRACEOFF (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	TRACEOFF_TSQL TRACEOFF DBCC TRACEOFF DBCC_TRACEOFF_TSQL
dev_langs	TSQL
helpviewer_keywords	trace flags [SQL Server], disabling DBCC TRACEOFF statement disabling trace flags
ms.assetid	1379afba-6480-454b-9c65-5e64cb4f3415
caps.latest.revision	34
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

DBCC TRACEOFF (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Disables the specified trace flags.

Transact-SQL Syntax Conventions

Syntax

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

Arguments

trace#
Is the number of the trace flag to disable.

-1
Disables the specified trace flags globally.

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

Remarks

Trace flags are used to customize certain characteristics controlling how the instance of [!INCLUDEssNoVersion] operates.

Result Sets

DBCC TRACEOFF returns:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.  

Permissions

Requires membership in the sysadmin fixed server role.

Examples

The following example disables trace flag 3205.

DBCC TRACEOFF (3205);   
GO  

The following example first disables trace flag 3205 globally

DBCC TRACEOFF (3205, -1);   
GO  

The following example disables trace flags 3205 and 260 globally.

DBCC TRACEOFF (3205, 260, -1);  
GO  

See Also

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