DBCC TRACEOFF (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance
Disables the specified trace flags.
Transact-SQL syntax conventions
Syntax
DBCC TRACEOFF ( trace# [ , ...n ] [ , -1 ] ) [ WITH NO_INFOMSGS ]
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
trace#
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.
Remarks
Trace flags are used to customize certain characteristics controlling how the instance of SQL Server operates.
Result sets
DBCC TRACEOFF
returns the following message:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Permissions
Requires membership in the sysadmin fixed server role.
Examples
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
See also
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin