title: Some tables id column do not auto increment despite being identity
body: <p>I am troubleshooting a db (not my forte) that has some tables that are auto incrementing on the id column and some tables are not?</p>
  
  <p>Now all the tables are set as identity and marked to disallow null. I am using SSMS what else can I check or do to get these tables back to auto incrementing?</p>
  
  <p>TIA</p>
  
  <p>Interestingly to me...probably old news to you guys. The issue had to do with existing data. So for example a table that had 100 rows in did <em>NOT</em> have the identity column setup. So I would go in and make it an identity with a seed of 1 incrementing 1. Well the seed was somehow having trouble because there was already 100 rows in there. So for all my tables I had to do a row count and seed the identity from the next row. Now it is working as expected.</p>