You cannot update an identity column, with or without SET IDENTITY_INSERT on.
You need to set the value as you load the table, not update it after it is loaded.
set identity_insert NewTable on
insert into NewTable (...col list...)
select
ID = ID+SomeValue ,
...col list ...
from
OldTable
set identity_insert NewTable off
You need to set the value as you load the table, not update it after it is loaded.
set identity_insert NewTable on
insert into NewTable (...col list...)
select
ID = ID+SomeValue ,
...col list ...
from
OldTable
set identity_insert NewTable off