Auto increment error

• muneeb-628674

  SSC Enthusiast

  Points: 111

  More actions

  January 9, 2013 at 6:37 am

  #269083

  I have a table like a customer table with customerid as the primary key which is an auto increment field with a seed of1 and increment of 1. Every thing was working fine until recently when the table reached around 9000 or so. Now instead of incrementing the I'd by 1, as is the table definition, the field is being incremented by a 1000 at a time. Again it is happening in a very haphazard fashion. It will increment a few by one and then skip a 10000 again.

  Any one that can explain it to me

• Gail Shaw

  SSC Guru

  Points: 1004514

  More actions

  January 9, 2013 at 6:46 am

  #1575220

  http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/a471e304-1160-4a27-aa9b-6c72ba7fbacc/

  https://connect.microsoft.com/SQLServer/feedback/details/739013/alwayson-failover-results-in-reseed-of-identity#details

  Despite the title, it's got nothing to do with always on. It's a restart of any form.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• muneeb-628674

  SSC Enthusiast

  Points: 111

  More actions

  January 10, 2013 at 10:30 am

  #1575892

  Thanks.

  So big brother put it "by design." ;>)