Hi!

Identity field on SQL server do not allow to change it. You require to insert records without identity field, identity values are auto-generated on the auto-increment basis. There is an option in SQL Serevr that allows to insert new record with specifying value for auto-increment field, that is why you get such error message.

>I am trying append to a sql server table as a remotve view. the sql server table has an id field. When i try to append, I receive the error message Identity insert is set off