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

The information in this article applies to:

Microsoft SQL Server 2000 (all editions)

This article was previously published under Q292737

BUG #: 352255 (SHILOH_bugs)

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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

WORKAROUND

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.

STATUS

Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.

MORE INFORMATION

Steps to Reproduce Behavior

To reproduce the problem, follow these steps:

Start the SQL Query Analyzer, and then connect to a SQL Server server.
Open Object Browser, expand Pubs, expand User Tables, and then expand dbo.authors.
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.

Modification Type:	Major	Last Reviewed:	11/6/2003
Keywords:	kbBug kbfix kbSQLServ2000sp1fix KB292737