DBCC TRACEOFF (Transact-SQL)

Disables the specified trace flags.

Transact-SQL Syntax Conventions

Składnia

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.

Uwagi

Trace flags are used to customize certain characteristics controlling how the instance of SQL Server 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

Zobacz także

Odwołanie

DBCC (Transact-SQL)

DBCC TRACEON (Transact-SQL)

DBCC TRACESTATUS (Transact-SQL)

Trace Flags (Transact-SQL)