Microsoft KB Archive/241363

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

Article ID: 241363

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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 '' 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 '' of object '', database '', owner ''.

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.

Additional query words: Error 924; 230

Keywords: kbbug kbpending KB241363

-

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

© Microsoft Corporation. All rights reserved.