Knowledge Base

BUG: UPDATE to View with Cursor May Cause Handled AV

Article ID: 179351

Article Last Modified on 10/3/2003

APPLIES TO

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 <cursor> 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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.