Converting text output of execution plans to graphical

Hi Guys,
does anyone know of any nice tools that will take the text output of a
profiler trace (with show execution plan traces on) and turn it into
the graphical version that you see through a query analyser?
Cheers
WillWill (william_pegg@.yahoo.co.uk) writes:
> does anyone know of any nice tools that will take the text output of a
> profiler trace (with show execution plan traces on) and turn it into
> the graphical version that you see through a query analyser?
If you are talking SQL 2000, I don't know any such tool.
However, in SQL 2005 you can capute the even Showplan XML, and as I reacall,
you can save that plan to disk, and then load into Mgmt Studio.
Nevermind that Query Analyzer has a better graphical presentation of
query plans.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx