Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
Disables the specified trace flags.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
DBCC TRACEOFF ( trace# [ ,...n ] [ , -1 ] ) [ WITH NO_INFOMSGS ]
Arguments
- trace#
Is 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.
Result Sets
DBCC TRACEOFF returns:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Remarks
Trace flags are used to customize certain characteristics controlling how the instance of Microsoft SQL Server 2005 operates.
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
Reference
DBCC (Transact-SQL)
DBCC TRACEON (Transact-SQL)
DBCC TRACESTATUS (Transact-SQL)
Trace Flags (Transact-SQL)