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

ID: Q217037

The information in this article applies to:
  • Microsoft SQL Server version 6.5
BUG #:18616 (SQLBUG_65)

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.


The client application may appear to stop responding or experience a disconnection from the server.


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
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.