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