FIX: Drag and Drop Object Type Node to the Editor in Query Analyzer Returns Error Message

This article was previously published under Q292737
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 352255 (SHILOH_bugs)
When you connect to a SQL Server server by using the SQL Query Analyzer, and you then attempt to drag & drop a node from the Object Browser to the Editor window, the following error message occurs:
No script generated.
This is caused by a delay loading mechanism that is built into the Object Browser, which was intended to improve Object Browser performance. This delay loading mechanism causes the Object Browser not to query the SQL Server server to retrieve all the node information when expanding the tree and hovering over a node.
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in theMicrosoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
To work around this problem, expand the node before you attempt to drag & drop the node into the Editor window. Note that you can subsequently shrink the node and it continues to work.
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

Steps to Reproduce Behavior

To reproduce the problem, follow these steps:
  1. Start the SQL Query Analyzer, and then connect to a SQL Server server.
  2. Open Object Browser, expand Pubs, expand User Tables, and then expand dbo.authors.
  3. Press and hold the mouse button while the mouse pointer hovers over the columns node, drag the node to the Editor window, and then release the mouse button.

Article ID: 292737 - Last Review: 01/16/2015 21:59:43 - Revision: 3.2

Microsoft SQL Server 2000 Standard Edition

  • kbnosurvey kbarchive kbbug kbfix kbsqlserv2000sp1fix KB292737