Display estimated execution plan problem

Hi all,
I have a complex query inside a stored procedure. When I try to see the
estimated query plan from Query Analyzer it hangs (I wait for at least one
minute).
When I stoped the QA with the red button it answers with a syntax error...
But there aren't syntax errors... I tried to do the same in another
environment and all things work.
Any idea?
Thank you very much!!
Alexandre Calderaro
Avanade Italy
Hi Alex my colleage :-)
Same Compatibility level ? If you use another compat. level some
statements might not be able to compile.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de

Display estimated execution plan bug

Hello. I'm using SQL2000, and I have a problem.
Each time I try to display estimated execution plan in Query Analyzer, the
graphical plan shows optimization costs 0%, 100%, or 600%, and the cost is
shown only for the first step. I installed sp4, but that didn't change
anything. I know I can use showplan_all, but it's better to have a graphical
display. I saw on Microsoft's web pages that this is a bug
(http://support.microsoft.com/defaul...Ben-us%3B274643), but
they are saying that it comes in some cases and I get it all the time.
Please help.
Draen Grabovac.Did you try to change the windows regional settings so that the decimal sepa
rator is . and not , ?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Grabi" <drazen@.git.hr> wrote in message news:dvjiib$kjf$1@.ss405.t-com.hr...
> Hello. I'm using SQL2000, and I have a problem.
> Each time I try to display estimated execution plan in Query Analyzer, the
> graphical plan shows optimization costs 0%, 100%, or 600%, and the cost is
> shown only for the first step. I installed sp4, but that didn't change
> anything. I know I can use showplan_all, but it's better to have a graphic
al
> display. I saw on Microsoft's web pages that this is a bug
> (http://support.microsoft.com/defaul...Ben-us%3B274643), but
> they are saying that it comes in some cases and I get it all the time.
> Please help.
> Draen Grabovac.
>

Display Estimated Execution Plan

Dear all,
I obtain a warning when I press the 'Display Estimated Execution Plan'
for the following sp:
up_Rpt_Data_Contents_Bridge_Wholesaler '2005-01-01','COW'
Server: Msg 208, Level 16, State 1, Procedure
up_Rpt_Data_Contents_Bridge_Wholesaler, Line 42
Invalid object name '#PERIODS'.
Query Analyzer is parsing all the contents for that object? Just a temp
table.
How can reckon something if not exists yet?
Thanks in advance and best regards,This is called "delayed name resolution" or something like that... SQL wil
l
repeast the name resolution when it executes the SP. Then, it checks the
actual code and makes sure that you are indeed creating a table named
#PERIODS.
"Enric" wrote:

> Dear all,
> I obtain a warning when I press the 'Display Estimated Execution Plan'
> for the following sp:
> up_Rpt_Data_Contents_Bridge_Wholesaler '2005-01-01','COW'
> Server: Msg 208, Level 16, State 1, Procedure
> up_Rpt_Data_Contents_Bridge_Wholesaler, Line 42
> Invalid object name '#PERIODS'.
>
> Query Analyzer is parsing all the contents for that object? Just a temp
> table.
> How can reckon something if not exists yet?
>
> Thanks in advance and best regards,|||Thanks for your feedback
"Enric" wrote:

> Dear all,
> I obtain a warning when I press the 'Display Estimated Execution Plan'
> for the following sp:
> up_Rpt_Data_Contents_Bridge_Wholesaler '2005-01-01','COW'
> Server: Msg 208, Level 16, State 1, Procedure
> up_Rpt_Data_Contents_Bridge_Wholesaler, Line 42
> Invalid object name '#PERIODS'.
>
> Query Analyzer is parsing all the contents for that object? Just a temp
> table.
> How can reckon something if not exists yet?
>
> Thanks in advance and best regards,|||Since your procedure creates a temp table and with "Estimated" no code is ex
ecuted, SQL Server
cannot show the plan as the table isn't created. Select Show execution plan"
and instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:BC203C72-A62E-460C-95FC-B2D707AD60DD@.microsoft.com...
> Dear all,
> I obtain a warning when I press the 'Display Estimated Execution Plan'
> for the following sp:
> up_Rpt_Data_Contents_Bridge_Wholesaler '2005-01-01','COW'
> Server: Msg 208, Level 16, State 1, Procedure
> up_Rpt_Data_Contents_Bridge_Wholesaler, Line 42
> Invalid object name '#PERIODS'.
>
> Query Analyzer is parsing all the contents for that object? Just a temp
> table.
> How can reckon something if not exists yet?
>
> Thanks in advance and best regards,|||It has been very useful.
Best wishes,
"Tibor Karaszi" wrote:

> Since your procedure creates a temp table and with "Estimated" no code is
executed, SQL Server
> cannot show the plan as the table isn't created. Select Show execution pla
n" and instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:BC203C72-A62E-460C-95FC-B2D707AD60DD@.microsoft.com...
>
>