BUG: Error 924 When Cursor is Executed in DB in Single-User Mode

ID: Q241363

The information in this article applies to:

Microsoft SQL Server version 7.0

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 version 7.0.

Additional query words: Error 924; 230

Keywords : kbSQLServ700bug kbDSupport
Version : winnt:7.0
Platform : winnt
Issue type : kbbug