The identity column, the insert and the linked server.

(Kenneth Fisher) tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted into if there is an identity column involved.

Register to Read