BUG: Current Database Not Correct After Use in Query Window

ID: Q121022

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server version 4.2x

BUG# 10141 (4.2)

SYMPTOMS

Doing a use <databasename> in the query window will reset the database named in the current database list box. However, the prior database listed in the box is the one still active as the current database.

Issuing a use command in a query window in Object Manager may cause the database listed in the current database list box to be incorrect. For example, if an sa whose default database is master connects with Object Manager, then opens a query window and issues the commands,


   use pubs
   go
   select * from authors
   go

and then closes the query window, the current database list box will indicate pubs is the current database. If the sa then clicks the objects button, the objects listed will be from the master database, not pubs.

WORKAROUND

Select the correct database in the current database list box to reset the current database, then reclick the objects window.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2 and SQL Server version 4.2b for OS/2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Windows NT

Keywords : kbtool SSrvObj_Man kbbug4.20 SSrvWinNT
Version : 4.2b | 4.2
Platform : OS/2 WINDOWS
Issue type :