This documentation is archived and is not being maintained.
DBCC TRACEOFF (Transact-SQL)
Disables the specified trace flags.
Transact-SQL Syntax Conventions
DBCC TRACEOFF ( trace# [ ,...n ] [ , -1 ] ) [ WITH NO_INFOMSGS ]
Is the number of the trace flag to disable.
Disables the specified trace flags globally.
- WITH NO_INFOMSGS
Suppresses all informational messages that have severity levels from 0 through 10.
DBCC TRACEOFF returns:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Trace flags are used to customize certain characteristics controlling how the instance of Microsoft SQL Server 2005 operates.
Requires membership in the sysadmin fixed server role.
The following example disables trace flag
The following example first disables trace flag
DBCC TRACEOFF (3205, -1);
The following example disables trace flags
DBCC TRACEOFF (3205, 260, -1);