The value of @@identity changes each time an insert or select into attempts to insert a row into a table. @@identity does not revert to its previous value if the insert or select into statement fails or if the transaction that contains it is rolled back.
Adding data using bcp does not change the @@identity value.
Workaround: None.
