Disables the specified trace flags.
Transact-SQL Syntax Conventions
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.
Trace flags are used to customize certain characteristics controlling how the instance of SQL Server operates.
DBCC TRACEOFF returns:
Requires membership in the sysadmin fixed server role.
The following example disables trace flag 3205
.
The following example first disables trace flag 3205
globally
The following example disables trace flags 3205
and 260
globally.
DBCC (Transact-SQL)
DBCC TRACEON (Transact-SQL)
DBCC TRACESTATUS (Transact-SQL)
Trace Flags (Transact-SQL)