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