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

• Microsoft SQL Server version 7.0

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.

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