title: Identity column value suddenly jumps to 1001 in sql server
body: <p>I am using Sql server 2012(Denali). I wonder why all identity column values start from 1001 and so on. At the beginning <code>Identity</code> column starts from 1,2 and so on and adding identity smoothly, but suddenly it jumps to 1001,1002 and onwards for all the table in the database containing identity column. What could be the reason? Please assist.</p>