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

• Microsoft SQL Server version 6.5 Service Pack 2 and later

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: June 25, 1999