FIX: AV in Cursoropen() If Using 'WHERE CURRENT OF' and Cancel

ID: Q189029


The information in this article applies to:
  • Microsoft SQL Server version 6.5 Service Pack 2 and later

BUG #: 17894 (SQLBUG_65)

SYMPTOMS

Canceling a transaction that is modifying data inside a cursor using WHERE CURRENT OF may cause a handled access violation (AV).


WORKAROUND

To work around this problem, do one of the following:

  • Change the WHERE CURRENT OF condition to a WHERE condition based on the primary key or other unique ID.


  • Do not do data modifications inside a cursor using WHERE CURRENT OF.


STATUS

Microsoft 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/.

For more information, contact your primary support provider.


MORE INFORMATION

This problem does not occur with SQL Server 6.5 Service Pack 1 or the release version of SQL Server 6.5.

Additional query words: prodsql exception SP SP2 SP3 SP4 SP5

Keywords : kbbug6.50.sp2 kbbug6.50.sp3 kbbug6.50.sp4 kbfix6.50.SP5
Version : winnt:6.5 Service Pack 2 and later
Platform : winnt
Issue type : kbbug


Last Reviewed: November 17, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.