1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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