sys.dm_exec_query

sys.dm_exec_query_plan

microsoft.public.sqlserver.programming

29 Jul 2006 7:33 PM

newscorrespondent

This SQL2005 function returns the query plan in XML format. Is there any
existing function that will take that XML and produce the plan in a
presentable format? perhaps like what you get when using Server Management
Studio?

Thanks
Tom

29 Jul 2006 8:25 PM

Dan Sullivan

if you give the xml file the extension .sqlplan then open it in SSMS you will get a graphic view of the plan.

29 Jul 2006 11:15 PM

newscorrespondent

That will certainly work well. I was hopping to be able to open a window in
my application and display that.

Thanks
Tom