identity increments by 10,000 when it was supposed to be 1

• stan

  Ten Centuries

  Points: 1384

  More actions

  June 16, 2026 at 10:46 am

  #4866738

  hi a peer of mine who ive never known to be wrong says a new table he created with pk identity(1,1) jumped by 10000 on one insert.   has anyone ever seen this anomaly?

  • This topic was modified 17 minutes ago by stan.

• Phil Parkin

  SSC Guru

  Points: 247225

  More actions

  June 16, 2026 at 12:56 pm

  #4866815

  Ask him for the code to reproduce the problem.

  Also ask whether the server was restarted between inserts.

  ---