Microsoft KB Archive/170436

= FIX: Infrequent Access Violation During LOAD TRANSACTION =

Article ID: 170436

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q170436



BUG #: 16946 (6.5)



SYMPTOMS
You may infrequently experience a handled access violation (AV) during a LOAD TRANSACTION. If you are running a debug version of SQL Server 6.5 (needed to ensure an accurate stack trace), you can determine that this AV occurs in the ldxact function.

If you use a LOAD DATABASE statement to reload the database and then use LOAD TRANSACTION to reapply the same transaction, the problem usually does not occur again.

The following is the stack trace from a 6.50.252 debug server:

ldxact + 0x178C

s_execute + 0x18FC

sequencer + 0x035C

language_exec + 0x06D6



WORKAROUND
To work around this problem, reload the database then reapply the same transaction files with LOAD TRANRANSACTION.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem was corrected in the latest Microsoft SQL Server 6.5 U.S. Service Pack. For information on obtaining the service pack, query on the following word in the Microsoft Knowledge Base (without the spaces):

S E R V P A C K

Keywords: kbbug kbfix kbusage KB170436

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.