>>>The only thing Gerard should check about that column is to avoid inserting duplicate values.
>If you omit the column from the insert statement, doesn't SQL Server populate it itself, eliminating the need to worry about duplicates?
It does, but when importing data the identity column is typically a key for other data - if it gets recreated RI is shot.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________