Because of column “ID“. The user did not have permission to write to the column

跨服务器Insert 提示

Because of column "ID". The user did not have permission to write to the column

实际上就是在同服务器Insert时

Cannot insert explicit value for identity column in table 'TableA' when IDENTITY_INSERT is set to OFF.

应该注意到TableA某字段，多是自增列，不允许插入值

Insert时避免插入该列即可。