Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Location
    Copenhagen, Denmark
    Posts
    5

    Unanswered: Old, deleted Identity values re-used?

    If I have an Identity-declared column, the table has lots of rows and I start deleteting records - will any old, deleted identities be re-used (without an explicit re-seed) ?

    (I'm talking about numerical Identities, not these GUID things)

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    No. Not without manipulating the IDENTITY column. The exception being that if you TRUNCATE the table, then the seed will reset to the floor value.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    Mar 2003
    Location
    Reading, UK
    Posts
    70
    yeah,it can be used
    need to set identity off
    insert statement
    reset identity on

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •