Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   problem with identity column (http://www.go4expert.com/forums/identity-column-t17328/)

fioryp 4May2009 17:09

problem with identity column
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

All times are GMT +5.5. The time now is 22:57.