Microsoft KB Archive/179351

= BUG: UPDATE to View with Cursor May Cause Handled AV =

Article ID: 179351

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q179351



BUG #: 17744 (6.5)



SYMPTOMS
An UPDATE of a view WHERE CURRENT OF a cursor may cause a handled access violation (AV), which stops the client thread on the SQL Server. This problem can occur if all of the following conditions are true:


 * The view joins three or more tables.
 * The innermost join condition is based on multiple columns.
 * The column updated is from the innermost table.



WORKAROUND
To work around this problem, do either of the following:


 * Change the WHERE clause of the UPDATE statement so that it does not use the CURRENT OF clause.

-or-
 * Declare the cursor on the underlying tables instead of on the view.



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: av violation prepscan

Keywords: kbbug kbsqlserv650bug KB179351

-

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

© Microsoft Corporation. All rights reserved.