DBCC TRACEOFF (Transact-SQL)
DBCC TRACEOFF ( trace# [ ,...n ] [ , -1 ] ) [ WITH NO_INFOMSGS ]
Is the number of the trace flag to disable.
Disables the specified trace flags globally.
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:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Requires membership in the sysadmin fixed server role.
The following example disables trace flag 3205.
The following example first disables trace flag 3205 globally
DBCC TRACEOFF (3205, -1);
The following example disables trace flags 3205 and 260 globally.
DBCC TRACEOFF (3205, 260, -1);