Problem In Primary Key

• deba_20032004

  Default port

  Points: 1476

  More actions

  June 15, 2012 at 6:57 am

  #258081

  Dear Sir,

  I am in great trouble that I have a primary key field which is data type is int and identity specified. but problem is i can't maintain sequence due to

  when I delete one record then i can't recover previous no. how to get back the previous serial no. please tell me

  Thanking you

  Debasis

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  June 15, 2012 at 7:07 am

  #1501609

  It shouldn't matter.

  But check out DBCC CHECKIDENT RESEED in BOL if you are adamant that it must be changed.

  ---

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 15, 2012 at 7:17 am

  #1501621

  Identities aren't supposed to maintain a sequence without gaps. Why does it matter?

  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

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  June 15, 2012 at 7:19 am

  #1501627

  IDENTITY is not meant to maintain an unbroken sequence. It is only meant to quickly produce a new unique value that is higher than the last one that was used.

  If you delete a row or if an insert fails, the IDENTITY value is not reused.