United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

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

Sample Database Enhancements (Transact-SQL)

Transact-SQL Data Types

Database Console Commands (DBCC) (Transact-SQL)

Data Definition Language (DDL) Statements (Transact-SQL)

Data Manipulation Language (DML) Statements (Transact-SQL)

Metadata (Transact-SQL)

Replication System Stored Procedures (Transact-SQL)

Other Statements (Transact-SQL)

Minimize

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.

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.

Reference

DBCC (Transact-SQL)

Other Resources

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

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.