Microsoft KB Archive/295727

= BUG: Object Browser May Not Reconnect After SQL Server Restart =

Article ID: 295727

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q295727



BUG #: 352396 (Shiloh)



SYMPTOMS
In situations where you do not close the Object Browser during a SQL Server restart, the Object Browser may fail to reconnect when you try to use the SELECT, INSERT, or UPDATE option. A message box asks if you wish to reconnect, but when you click Yes, nothing happens.

The other options (such as DELETE, CREATE, and DROP) are available and function properly.



WORKAROUND
You can work around this problem in the following ways:
 * Expand a sublevel node (such as &quot;Columns&quot;) under a specific table. The same message box appears and when you click Yes, the connection is reestablished.
 * Close and then reopen the Query Analyzer/Object Browser.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.



Steps to Reproduce Behavior

 * 1) Make a connection to SQL Server from Query Analyzer.
 * 2) Expand to &quot;User Tables&quot; or &quot;System Tables&quot;.
 * 3) Restart SQL Server.
 * 4) Right-click a table, point to Script object to new window as, and click Select, Insert, or Update.
 * 5) When the message box appears, click Yes, and nothing happens.

Additional query words: Object Browser

Keywords: kbbug kbpending KB295727

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.