June 15, 2009 at 8:33 am
In SS2008 when you view an xml execution plan in sql server, it will still show the graphical execution plan. This is because the schema is located within 2008. Is it possible to import the schema for 2005? If so, how?
Thanks,
Fraggle
June 15, 2009 at 8:41 am
Not sure I understand your question.
The behaviour of the exec plans in management studio is pretty much the same between 2005 and 2008 and, as far as I know, the scherma of that XMl hasn't changed between the two. I can open exec plans that were saved in 2008's management studio in 2005's management studio and vis versa.
What is it that you're trying to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2009 at 8:52 am
Gila,
When using the SET STATISTICS_XML ON, you get an xml execution plan for the query that was just executed. When this xml string is clicked on in 2008, it automatically brings up a graphical execution plan. In 2005, it brings up the xml code. As I understand it, this has to do with the fact that 2005 is missing the correct schema to make this happen. What I am wondering is, how can I go about importing this schema into 2005.
Thanks,
Fraggle
June 15, 2009 at 9:04 am
No, that's purely got to do with the way management studio's programmed.
In 2005, click on the xml string to bring the xml up in a separate window. Save the xml, specifying a .sqlplan extension. Close the window that has the raw XML. Go to File - Open and open the .sqlplan file that you just saved.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2009 at 9:13 am
Gila,
Thanks for the assist.
Fraggle
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply