Sessions: 411 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Saturday, November 23, 2024
Wider View Login

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
          CHECKDB With Data Pu...
          Displaying a trace o...
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
Windows OS


Will be added as a sub-category of, DBCC
Displaying a trace of the output of the DBCC command
The command: DBCC TRACEON (3604) is required before a DBCC command in order to see the effects of the command by displaying a trace of the output of the DBCC command. It is not actually required to run the DBCC command. If you run any DBCC command without the above option, the command runs, but you don't see what it is doing.