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


The information in this article applies to:

  • Microsoft SQL Server 7.0
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 '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 7.0.
Modification Type:MajorLast Reviewed:9/4/2002
Keywords:kbbug KB220842
©2002 Microsoft Corporation. All rights reserved.