Microsoft KB Archive/197581

= BUG: QA: No Execution Plan for DECLARE CURSOR & SELECT...FOR BROWSE =

Article ID: 197581

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q197581



BUG #: 50958 (SQLBUG_70)



SYMPTOMS
In Query Analyzer, when you set the Execution Mode to show the execution plan (either by clicking Show Execution Plan on the Query menu, or by using the CTRL+K keystroke combination) on a DECLARE CURSOR statement, it does not display a plan for cursor statements. If you click Display Estimated Execution Plan on the Query menu (or use the CTRL+L keystroke combination), you do see the execution plan for cursors.



CAUSE
When you set the Execution Mode to show the execution plan, the execution plan contains IO statistics information. Because cursors do not support IO statistics, an execution plan is not displayed. In Estimated Execution Plan mode, IO statistics are not part of the execution plan.



WORKAROUND
To work around this problem, use the Estimated Execution Plan (CTRL+L).



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words: QA CRTL

Keywords: kbbug kbpending KB197581

-

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

© Microsoft Corporation. All rights reserved.