Lost table Identity

• jack_stockton

  Newbie

  Points: 9

  More actions

  February 22, 2011 at 9:46 am

  #231569

  One of my tables no longer auto-increments records that are added. When adding records I am having to include the value for the Key.

  I thought this would work, but neither value helped.

  SET IDENTITY_INSERT tablename ON

  SET IDENTITY_INSERT tablename OFF

  How do I get it back?

• ChazMan

  SSCrazy

  Points: 2259

  More actions

  February 23, 2011 at 12:40 pm

  #1290583

  no those won't work. they are used to allow you to insert the identity values in your SQL INSERT statements.

  You need to alter the table and redefine the field as an identity field. I strongly suggest you backup the database before you do that!

  --------------------------------------------------------------------------
  When you realize you've dug yourself into a hole....Step 1...stop digging.