Microsoft KB Archive/292737

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

Article ID: 292737

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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.



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.

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB292737

-

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

© Microsoft Corporation. All rights reserved.