Microsoft KB Archive/217037

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

Article ID: 217037

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q217037



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 6.5.

Additional query words: hang hangs hung db

Keywords: kbbug kbpending KB217037

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.