title: Update stored procedure in Code First DbMigration
body: <p>I have solution for Stored Procedures creation exactly like in this answer <a href="https://stackoverflow.com/a/15171900">https://stackoverflow.com/a/15171900</a>.</p>
  
  <p>I am running</p>
  
  <pre><code>Sql(Properties.Resources.Create_sp_DoSomething);
  </code></pre>
  
  <p>in my Initial DbMigration.</p>
  
  <p>My sql scripts have code to first drop existing SP and then create new updated SP. So whene I run </p>
  
  <pre><code>Sql(Properties.Resources.Create_sp_DoSomething);
  </code></pre>
  
  <p>in new DbMigration, and logic inside SP is changed everything works fine.</p>
  
  <p>The problem arise when I want to update Stored Procedure with columns (lets say <em>IsActive</em>) which were added to model in later commits, and I am updating without existing DB (so new DB is created).
  Then It fails with </p>
  
  <blockquote>
    <p>Invalid column name 'IsActive'.</p>
  </blockquote>
  
  <p>Any good solution to that other than removing all existing calls to</p>
  
  <blockquote>
    <p>Sql(Properties.Resources.Create_sp_DoSomething);</p>
  </blockquote>
  
  <p>and have it only in newest DbMigration.</p>