Display estimated execution plan problem

microsoft.public.sqlserver.tools

16 Oct 2006 5:31 PM

Alex

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

16 Oct 2006 7:02 PM

Jens

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
---