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


  Sunday, October 1, 2023
Wider View Login

IBM - AS400
Performance Counters
Service Broker
SQL Server
     Temporary Database
     SQL Mail
     DTS - Data Transformation Services
     Jobs SQL Agent
          CHECKDB With Data Pu...
          Displaying a trace o...
     User Management
     System Databases
     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.