BUG: Cursor Update (sp_cursor) with a SELECT on View After LOAD DATABASE Causes AV (217037)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbbug kbpending KB217037 |
|---|
|