TechNet
Expand All
This documentation is archived and is not being maintained.

Database Console Commands (DBCC) (Transact-SQL)

In Microsoft SQL Server 2005, trace flags can be set globally. The following DBCC commands can be used to enable, disable, and display the status of trace flags.

DBCC command Description

DBCC TRACEON

Enables trace flags globally.

DBCC TRACEOFF

Disables trace flags that have been set globally.

DBCC TRACESTATUS

Displays trace flags that have been set globally.

Show:
© 2016 Microsoft