title: How can I display the execution plan for a stored procedure?
body: <p>I am able to view the Estimated Execution Plan (Management Studio 9.0) for a query without a problem but when it comes to stored procedures I do not see an easy way to do this without copying the code from the ALTER screen and pasting it into a query window, otherwise it will show the plan for the ALTER and not the procedure. Even after doing this, any inputs are missing and I would need to DECLARE them as such.</p>
  
  <p>Is there an easier way to do this on stored procedures?</p>
  
  <p><strong>Edit:</strong>
  I just thought of something that might work but I am not sure.</p>
  
  <p>Could I do the estimated execution plan on</p>
  
  <pre><code>exec myStoredProc 234
  </code></pre>