Tuesday, July 8, 2014

Identity Column value jumps to 1001 in SQL Server 2012

Recently we upgraded database from SQL Server 2008 to SQL Server 2012 version, We identified an issue with Auto increment identity columns.

If we restart SQL Server 2012 instance Identity column (auto-increment) value suddenly jumps to 1001 if the datatype is int and jumps to 10000 if the datatype is bigint.

Workaround:
Dont use auto-increment identity columns and use sequence feature in SQL Server 2012.


No comments: