[fioryp]

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