problem with identity column

Discussion in 'SQL Server' started by fioryp, May 4, 2009.

  1. fioryp

    fioryp New Member

    May 4, 2009
    Likes Received:
    Trophy Points:
    I have a table with a primary key int identity
    in this table i make a lot of insert and a lot of cancellation. I put the data i cancel in an archive table.

    I have a big problem in this table the identity number i have cancelled, after one year of working use, sql server now gives me as primary key these numbers i have already in my archive table.

    I need to have a primary key unique for all the life of this table i have to make sql server makes new primary key and not use number i have cancelled and moved to archive!!!

    Sorry for my english!!
    Thank you for all your support

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice