SQL Server 2012 Auto Identity Column Value Jump Issue

S. M. Ahasan Habib

Rate me:

4.85/5 (56 votes)

14 Oct 2013CPOL3 min read

338K

From SQL Server 2012 version, when SQL Server instance is restarted then its auto Identity column value is jumped based on identity column datatype.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

S. M. Ahasan Habib

Architect

Bangladesh

How do I describe myself to you? How can I explain that this is true?
I am who I am because of you! My work I love you !!