title: t-sql stored procedure create scripts
body: <p>I have a bunch of stored procedure names. I want to export the create script for each of the stored procedure. What is the best way to do it? </p>
  
  <p>Right now I am manually selecting the stored proc in SSMS and selecting <code>"Script stored procedure as -&gt; Drop and Create to"</code>. This seems tedious. I am hoping there is a better way to deal with this. Thanks.</p>