BUG: Cursor Update (sp_cursor) with a SELECT on View After LOAD DATABASE Causes AV

• Microsoft SQL Server version 6.5

SYMPTOMS

You may experience a handled access violation (AV) when a stored procedure is executed after loading a database if the following conditions are met:

• A cursor is opened on the stored procedure.



• The stored procedure selects from a view.



• The cursor is used to update the base table used in the view.

WORKAROUND

To work around this problem, drop and re-create the view(s) involved in the stored procedure after the database is loaded.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5.

Additional query words: hang hangs hung db

Keywords          : SSrvODS SSrvTran_SQL 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: March 6, 1999