?
Solved

Save execution plan to another program

Posted on 2007-04-02
2
Medium Priority
?
229 Views
Last Modified: 2010-03-19
I have a rather large and complex query in SQL Server 2005 which I have to sroll all over the place to view it's execution plan.  Is it possible to save the Execution Plan to another application for viewing other than using screen shots?

Is there a trick?
A third party app?

Help!?!?!
0
Comment
Question by:CLoprinzo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
rboyd56 earned 750 total points
ID: 18838745
This may not be what you are looking for but with Profiler you can save the showplan to a well defined XML document.

Just choosse one of teh events under Performance  section (make shure you show all events)
0
 
LVL 1

Author Comment

by:CLoprinzo
ID: 18850268
Although it added an additional step it did answer my question.  Thank you.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question