Home All Groups Group Topic Archive Search About

SSMS hangup when using actual execution plan with for XML clause

Author
1 Mar 2007 7:41 AM
W.D. Nijdam
When I enable "display actual execution plan" and run a query with a "FOR
XML" clause, SQL Server management studio hangsup. Very annoying because any
changes to SQL query files are lost.

Author
1 Mar 2007 10:32 PM
Erland Sommarskog
W.D. Nijdam (WDNij***@discussions.microsoft.com) writes:
> When I enable "display actual execution plan" and run a query with a
> "FOR XML" clause, SQL Server management studio hangsup. Very annoying
> because any changes to SQL query files are lost.

Which version of Mgmt Studio do you have? SP2 was released recently.
I did a quick test, but I was not able to reproduce the error. I'm
running SP1 of SQL Server.

Of course, the problem may be specific to your query and appear with
any FOR XML query.


--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

AddThis Social Bookmark Button