Export (0) Print
Expand All

Database Console Commands (DBCC) (Transact-SQL)

SQL Server 2005

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft