Retrieving a distal query plan

Hi!
I have a consultant onsite at a client, and she's sending back
pictures of the query plan for a script with a performance issue. These
are useful, as they're turning out somewhat different from the
development and test machines. But, is there any way we can pass the
query plan so that I can look at it in Query Analyzer's fine query plan
renderer?
Thanks!
IonIon,
SQL Server 2005 has this feature, but not SQL Server 2000.
In SQL Server 2005 Management Studio, you can save and
reopen query plans saved as .sqlplan files (which are XML files).
There might be a third-party tool that can render the graphical plan
from the SHOWPLAN_TEXT text plan - at least it's conceivable -
but I don't know of one.
Steve Kass
Drew University
ionFreeman@.gmail.com wrote:

>Hi!
> I have a consultant onsite at a client, and she's sending back
>pictures of the query plan for a script with a performance issue. These
>are useful, as they're turning out somewhat different from the
>development and test machines. But, is there any way we can pass the
>query plan so that I can look at it in Query Analyzer's fine query plan
>renderer?
>Thanks!
>Ion
>
>|||I think I heard that you can use SQL Server 2005 Management Studio
against a 2000 database, and that it will allow you to save the plan
and send it as with any 2005 database.
Roy Harvey
Beacon Falls, CT
On Fri, 28 Apr 2006 19:51:02 -0400, Steve Kass <skass@.drew.edu> wrote:
>Ion,
>SQL Server 2005 has this feature, but not SQL Server 2000.
>In SQL Server 2005 Management Studio, you can save and
>reopen query plans saved as .sqlplan files (which are XML files).
>There might be a third-party tool that can render the graphical plan
>from the SHOWPLAN_TEXT text plan - at least it's conceivable -
>but I don't know of one.
>Steve Kass
>Drew University
>
>ionFreeman@.gmail.com wrote:
>|||Thanks, guys. I'll see where this brings me.