The information in this article applies to:
BUG #: 17399 (NT: 6.5) SYMPTOMSDeleting a table that includes at least one text or image datatype by using Transact-SQL statements EXISTS or NOT EXISTS and a correlated subquery, will not properly escalate page locks to a table lock. Although sp_lock will show an Ex_table lock on the table, Ex_page locks will continue to be acquired, in excess of the LE threshold, for all pages involved in the deletion. On larger tables, such deletions can exhaust available locks and generate a system message 1204: This is a regression bug for 6.50.258 Service Pack 3 (SP3). The symptoms are not seen in 6.50.201 (base release) or 6.50.240 (SP2). WORKAROUNDYou can work around the problem by using either of these methods:
or STATUSMicrosoft has confirmed this to be a problem in SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 5a
for Microsoft SQL Server version 6.5. For information about
downloading and installing the latest SQL Server Service Pack, see
http://support.microsoft.com/support/sql/.
Additional query words: prodsql sp3 sp5 correlated escalation escalate decouple
Keywords : SSrvLock kbbug6.50.sp3 kbfix6.50.SP5 |
Last Reviewed: November 17, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |