Home Forums SQL Server 2012 SQL 2012 - General IDENTITY(1,1) doesn't work, from 17 jumped to 1001 RE: IDENTITY(1,1) doesn't work, from 17 jumped to 1001

  • April 1, 2014 at 3:47 am

    #1701929

    mario17 (3/31/2014)

    Thanks, all

    Yes, I did reseed and it worked.

    DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);

    The problem here is, when the value jumped if identities were created in the upper range and you reseed back to 10, you'll have issues later

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉