SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
3 out of 6 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.