Microsoft KB Archive/220842

= BUG: Error 924 When Cross-Database Query Run from Context of Database in Single User Mode =

Article ID: 220842

Article Last Modified on 9/4/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q220842



BUG #: 54404 (SQLBUG_70)



SYMPTOMS
If the following sequence of events occurs, you may receive error 924:
 * 1) A connection is made to a database in single user mode.
 * 2) From another connection, a query is run against the database that is in single user mode.
 * 3) A cross-database query is run from the first connection.

The following is error 924:

Server: Msg 924, Level 14, State 1, Line 0

Database ' ' is already open and can only have one user at a time.



WORKAROUND
To work around this problem, either avoid making cross-database queries from a database in single user mode, or avoid querying a database that is in single user mode.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: err message msg

Keywords: kbbug kbpending KB220842

-

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

© Microsoft Corporation. All rights reserved.