title: Can a VS2010 Database Project create re-runnable deployment scripts?
body: <p>I’m using VS2010 Database Projects as a way of versioning our database code between release versions. So far, the solution provided seems good; however there is one problem I wonder if anyone else has run into.</p>
  
  <p>The upgrade scripts generated from the schema compare view are not re-runnable. As a standard, I normally ensure that all my database release scripts are re-runnable, just in case there should be any issues deploying the release script to a server. </p>
  
  <p>Does anyone know if there is a way to configure VS2010 to create re-runnable upgrade scripts i.e. drop sprocs only if they exist etc.?</p>