DBCC TRACEOFF (Transact-SQL)
Disables the specified trace flags.
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
DBCC TRACEOFF (3205); GO
The following example first disables trace flag
DBCC TRACEOFF (3205, -1); GO
The following example disables trace flags
DBCC TRACEOFF (3205, 260, -1); GO