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

ID: Q220842

The information in this article applies to:
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 'db_name' 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 version 7.0.

Additional query words: err message msg 


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

Last Reviewed: March 11, 1999