View execution plan by default

• Ian Crandell

  SSCommitted

  Points: 1603

  More actions

  February 25, 2008 at 9:46 am

  #186925

  Hello,

  Does anyone know if there is an option for the query analyzer to have "Show Execution Plan" on by default? I usually remember to turn it on after I have executed a query and realize I wanted to see the execution plan.:pinch:

  I would like to know if this is possible in both 2000 and 2005.

  Thanks,

  Ian.

  "If you are going through hell, keep going."
  -- Winston Churchill

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 25, 2008 at 10:21 am

  #781659

  I am not aware of a way to default this behavior. If you find a way let me know.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question