Microsoft KB Archive/121022

{|
 * width="100%"|

-

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 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 :
 * }