I am trying to insert rows from server1.table1 to server2.table2. I already create a linked server in order to query tables in both servers and it works.
However because server2.table2 has an identity column,and though I put the hint
set identity_insert table2 on,
the insert operation failed and I got the following errors in french:
L'objet "192.168.0.36.wt_delivery.dbo.table2" est introuvable, car il n'existe pas ou vous ne disposez pas des autorisations requises.
which mean that the object 192.168.0.36.wt_delivery.dbo.table2 is not found or we don't have the required permission to do the operation.
when I create the same table without the identity column the insert operation succeed!!
The query was executed from server1
Is there a specific permission that allow the operation to succeed or the problem is not at permission level?