BUG: UPDATE to View with Cursor May Cause Handled AV (179351)


The information in this article applies to:

  • Microsoft SQL Server 6.5
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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbSQLServ650bug KB179351 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.