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.

Enhanced DBCC Commands

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.

See Also

Reference

DBCC (Transact-SQL)

Other Resources

What's New and Enhanced in Transact-SQL (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance