Tag Info

New answers tagged

2

There are many things that can cause gaps in an IDENTITY column (rollbacks, deletes), but in this case due to the jump I suspect it is this bug - caused by the changes to IDENTITY with the introduction of SEQUENCE: Connect # 739013 : Failover or Restart Results in Reseed of Identity So I bet that if you look in SQL Server's error logs, the rows ...


2

When inserts are rolled back, the identity values are NOT reset. This is one explanation of the so called "skipped" values.



Top 50 recent answers are included