0

I use SQlServer 2014 Express, in many table I use the classical primary key with this setting:

enter image description here

After some classical insert by sql I have a jump in ID number.

enter image description here

I use SQL Server for many years but I have never had this. Can you tell me why this happens?

daniele3004
  • 13,072
  • 12
  • 67
  • 75
  • 3
    **[identity increment is jumping in sql server database](http://stackoverflow.com/questions/14146148/identity-increment-is-jumping-in-sql-server-database)** It is a [feature](https://connect.microsoft.com/SQLServer/feedback/details/739013/failover-or-restart-results-in-reseed-of-identity) :) Could we close it as duplicate or do you need additional assistance? – Lukasz Szozda May 02 '16 at 07:24
  • 1
    @lad2025 Thank you, you can mark as duplicated – daniele3004 May 02 '16 at 10:12

0 Answers0