DBCC TRACEOFF (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance
Disables the specified trace flags.
Transact-SQL syntax conventions
DBCC TRACEOFF ( trace# [ , ...n ] [ , -1 ] ) [ WITH NO_INFOMSGS ]
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 the following message:
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.
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