Article ID: 165166
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q165166
BUG#: 16666 (6.5)
SYMPTOMS
With Insert Row Locking (IRL) turned on, if lock escalation occurred during an index page split, and the transaction was still open when 'dump tran' was performed, 'load tran' using this dump file may result in any one of the following error messages:
CAUSE
The log record type was set to IRL at beginning of the transaction, but size was set to something else since lock escalation had occurred.
WORKAROUND
It is possible to avoid this problem by increasing sp_configure option 'LEThreshold Maximum'. See SQL Server Books-Online for more information on this option.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.
Additional query words: tlog wrong begin incomplete rollback forward abort
Keywords: kbbug kbfix kbusage KB165166