Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chetan06
Starting Member
11 Posts |
 Posted - 2007-03-30 : 01:28:37
|
| Hi Friends,I wanted to know how i can save the output of Query Execution Plan?Cjain |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-30 : 01:40:43
|
| Add this statement before executing query:SET SHOWPLAN_TEXT ONGOexecute the query and copy the resulting textual execution plan to a file to save it.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
chetan06
Starting Member
11 Posts |
Posted - 2007-03-30 : 02:31:17
|
| Hi Harsh,But this option wips out all the diagramatical presentation of the execution plan.All the information remains but in the text format which is not so useful.Can't we saved the exuection plan in the same way as it is shown.Cjain |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-30 : 03:41:13
|
| You can always use Print Screen and save it as a bitmap.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
chetan06
Starting Member
11 Posts |
Posted - 2007-03-30 : 05:12:17
|
| Thanks for the help......Cjain |
|
|
|
|
|
|
How to save Output of Query Execution Plan