Microsoft KB Archive/152046

{|
 * width="100%"|

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