Execution Plan

• houston

  Ten Centuries

  Points: 1257

  More actions

  January 5, 2006 at 11:49 am

  #112128

  Is there a way to save the Execution Plan to a file?

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  January 5, 2006 at 8:47 pm

  #613095

  Hi ,

   

  There is no way to save the execution plan out put in a text file.

  from

  Killer

• Anjani Kumar Singh

  Newbie

  Points: 2

  More actions

  January 5, 2006 at 9:42 pm

  #613097

  Hi,

  In SQL Server 2005, you can do so.

  Refer to

  http://msdn2.microsoft.com/en-us/library/ms190646(en-us,VS.90).aspx

  Regards,

   

  ---

  Kindest Regards,

  Anjani Kumar Singh
  A man with nothing to live for has everything to fight for

• sql_servant

  Old Hand

  Points: 315

  More actions

  January 9, 2006 at 4:38 pm

  #613697

  If you run SET SHOWPLAN_TEXT ON before your query, you'll get a bunch of hideous text that I believe is the equivalent of the hideous graphical output of Query Analyzer Showplan.

  You can save the text in the results window to a file.

  Don't know if that's what you were looking for...

  
  Chris Hofland