
Why we should enable trace flag 3604 before part of DBCC statements?
In many cases, while we using DBCC commands, we must to run two statements instead of one, in order to receive the wishful result. For example, in order to receive database information, we write: DBCC TRACEON (3604); GO DBCC DBINFO (‘AdventureWorks2012’); GO instead of simple: DBCC DBINFO (‘AdventureWorks2012’); GO So, why we need to use additional statement, why we enable trace flag 3604 before part of the DBCC commands? The answer consists of two parts: 1. Most of the trace