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 Fiorella
