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

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

Q152046

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG#: 13262 (6.00)

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 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 6.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:

http://support.microsoft.com/highlights/sql.asp

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 : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600