SQL SERVER – Add or Remove Identity Property on Column | Journey to SQL Authority with Pinal Dave

Hi pinal sir, SQL Server 2012 identity problem In my case I created a table with identity, inserted 7 records (identity 1-7) The next record I inserted it was 1002 – inserted 2 more and it was 2002 . I Don’t know the exact problem , It may be because of 1

blog.sqlauthority.com