| Author |
Topic |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2008-02-29 : 09:03:45
|
Does anyone know of a good way to copy the execution plan when using "Include Actual Execution Plan"?I often need to copy this and mail it.I know I can use PrintScreen button, but I need a more efficient way to do this.If I just could rightclick the execution plan and select "Copy" and get complete plan it would be great.Mladen?
E 12°55'05.25"N 56°04'39.16" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-29 : 09:14:34
|
| XML execution plan is the only choice I guess.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-29 : 09:22:00
|
You mean SET SHOWPLAN_XML ON?How to send that with mail so that receiver can see it?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-02-29 : 09:22:09
|
| SET SHOWPLAN_XML ONorSET SHOWPLAN_TEXT ON--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-29 : 09:25:10
|
Yes, I can send that as XML to another SQL developer.But how to include it as an image to a document or an intranet page.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-29 : 09:31:38
|
| You want to mail it from SQL Server itself or by using Mail client like outlook?If it is external mail client, you can just save execution plan as a file and send it as an attachment.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-29 : 09:36:11
|
I also want to paste it into a document for presentations. That could be both Powerpoint or Word, depending on the audience.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-02-29 : 09:46:17
|
| This article might do you some good but from what I can understand a printscreen will at some point be required...http://www.mssqltips.com/tip.asp?tip=1366--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4" |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-29 : 10:08:51
|
Another feature which Mladen could add to his SSMS toolpack!  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-04 : 09:21:15
|
| this is acctualyl not that hard to do ... i think...might be in the 1.1 version..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-04 : 09:28:04
|
The major problem might be which execution plan "graph" to copy?As of now, I have 24 execution plan graphs for complete stored procedure and it is graph 14 I am interested in.Beacuse today I have to use printscreen, paste to Paint, scroll execution plan and copy next sequence and paste Paint and tile the new picture accordingly. repeat this until full execution plan is copied and then remove unwated area such as scroll bars.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-04 : 09:40:08
|
| harsh, are you using it? if you do what do you think of it?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-04 : 09:56:44
|
Mladen, I have recently started using it and finding it useful.  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-03-04 : 10:00:21
|
| Mmmm, you just gotta love Paint Have they done any changes to it over the last 15 years??--Lumbago"SELECT Rum, Coke, Lime, Ice FROM bar WHERE ClosingTime = 'Late' AND FemaleMaleRatio > 4" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-04 : 10:36:22
|
| i use Paint.NET. ROCKS!_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
Execution plan