BUG: UPDATE to View with Cursor May Cause Handled AV

• Microsoft SQL Server version 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          : SSrvGPF SSrvTran_SQL kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 21, 1999