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)
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:
(http://support.microsoft.com/kb/290211/EN-US/ )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 BehaviorTo reproduce the problem, follow these steps: