title: Increase value of an identity column in SQL Server without dropping and recreating the table
body: <p>In a table, I have an ID column, that is an Identity int.</p>
  
  <p>How can I make it so that the next row inserted will get identity 10000 (I believe this is called the identity seed) - without dropping and recreating the table?</p>
  
  <p>I need to do this because of a uniqueness issue with an external service, the app accesses.</p>