BUG: Object Browser May Not Reconnect After SQL Server Restart (295727)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
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 "Columns") 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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Make a connection to SQL Server from Query Analyzer.
  2. Expand to "User Tables" or "System Tables".
  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.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug kbpending KB295727
©2003 Microsoft Corporation. All rights reserved.