BUG: Error 924 When Cursor is Executed in DB in Single-User Mode (241363)
The information in this article applies to:
This article was previously published under Q241363
BUG #: 56364 (SQLBUG_70)
SYMPTOMS
If a connection is processing a cursor in a database in single-user mode and another connection tries to use the database, both the connections produce the following error:
Server: Msg 924, Level 14, State 1, Procedure sp_cursorfetch, Line 9
Database '<db_name>' is already open and can only have one user at a time.
The processing of the cursor stops and returns multiple occurrences of the error 230 in the first connection:
Server: Msg 230, Level 14, State 1, Procedure sp_cursorfetch, Line 9
SELECT permission denied on column '<column_name>' of object '<table_name>', database '<db_name>', owner '<owner_name>'.
This happens with all types of concurrency and scroll options for the cursor.
WORKAROUND- Avoid using cursors when the database is in single-user mode.
- Avoid attempts to make multiple connections to a database in single-user mode.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.
| Modification Type: | Major | Last Reviewed: | 10/16/2002 |
|---|
| Keywords: | kbBug kbDSupport KB241363 |
|---|
|