Skip to content

dbcc-traceoff-transact-sql.md

Latest commit

 

History

History
94 lines (66 loc) · 2.27 KB

dbcc-traceoff-transact-sql.md

File metadata and controls

94 lines (66 loc) · 2.27 KB
title DBCC TRACEOFF (Transact-SQL)
description DBCC TRACEOFF disables the specified trace flags.
author rwestMSFT
ms.author randolphwest
ms.date 12/05/2022
ms.service sql
ms.subservice t-sql
ms.topic reference
f1_keywords
TRACEOFF_TSQL
TRACEOFF
DBCC TRACEOFF
DBCC_TRACEOFF_TSQL
helpviewer_keywords
trace flags [SQL Server], disabling
DBCC TRACEOFF statement
disabling trace flags
dev_langs
TSQL

DBCC TRACEOFF (Transact-SQL)

[!INCLUDE SQL Server - ASDBMI]

Disables the specified trace flags.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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

Arguments

trace#

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 the following message:

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