Change the starting value for the next record in an identity column

• Roust_m

  SSCoach

  Points: 17410

  More actions

  August 2, 2007 at 7:09 pm

  #118144

  Hi,

  For testing purposes, I need to make the next record in a table to get a value above 33000 for an identity column.  The current number of records in the table is only ~13000.  Apart from changing the increment value, are there any other methods to do this?

  Thanks.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  August 2, 2007 at 7:27 pm

  #724366

  DBCC CHECKIDENT

  _____________
  Code for TallyGenerator

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  August 2, 2007 at 7:28 pm

  #724367

  Or you can set IDENTITY_INSERT ON and manually insert a row with ID = 32999.

  

  Don't forget to set IDENTITY_INSERT back OFF and delete that row afterwards.

  _____________
  Code for TallyGenerator