FIX: DBCC Traceon(3604,4031) Causes Unhandled Access Violation

• Microsoft SQL Server version 6.0

SYMPTOMS

Using the combination of trace flags 3604 (sends trace output to the client) and 4031 (prints both a byte and ASCII representation of the send buffers) can crash the server with an unhandled access violation and stack overflow.

The following is an example:

dbcc traceon(3604)
go
dbcc traceon(4031)
go 

WORKAROUND

To work around this problem, send trace output to the error log file, as in the following example:

dbcc traceon(3605)
go
dbcc traceon(4031)
go 

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

This problem does not occur in SQL Server version 6.5 or 7.0.

Additional query words: SQL6 TRACEFLAG AV

Keywords : kbprg SSrvProg kbbug6.00
Version : winnt:6.0
Platform : winnt
Issue type : kbbug