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

Article translations Article translations
Article ID: 292737 - View products that this article applies to.
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)
Expand all | Collapse all

On This Page


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 the Microsoft 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: January 16, 2015 - Revision: 3.2
  • Microsoft SQL Server 2000 Standard Edition
kbnosurvey kbarchive kbbug kbfix kbsqlserv2000sp1fix KB292737

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from