Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GreatInca
Posting Yak Master
102 Posts |
 Posted - 2006-05-18 : 16:55:38
|
A lot of more complicated queries seem to not be able to get execution plans in SSMS..Error processing execution plan results. The error message is:There is an error in XML document (1, 32769).Unexpected end of file while parsing Name has occurred. Line 1, position 32769.This error seems to show that a XML line is exceeding some sort of 32K limit and truncates.It seems to happen on every large query or a stored procedure with a large select statement. More moderate queries are affected when hitting catalog views. Stored procedures with multiple small selects don't give the error.Works fine in SQL 2000/SSMS and 2005/QA and 2000/QA. Execution plans only break in large select statements 2005/SSMS. It is broken in both the RTM and SP1. LinkSite: http://www.greatinca.netBlog: http://www.greatinca.net/BlogPictures: http://www.pbase.com/GreatIncaMySpace: http://www.myspace.com/GreatInca |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-19 : 00:57:40
|
| Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66334 |
 |
|
|
|
|
|
Errors getting execution plan in SQL 2005 / SSMS