Hello there

I have two servers connected by linked server.

I'm trying to insert data on server2 from server1

Here is what i'm trying to run:
INSERT SVR2.db.dbo.Table1(Field1, Field2, Field3)
VALUES(1,2,3)

And i'm getting this error:

[OLE/DB provider returned message: Cursor operation conflict]

OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow
returned 0x80040e23: Unknown provider error.].

what's wrong in my code:

How To incorporate table-valued function in Common Table Expressio
Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
Getting 10 Records the Fastest Way Possible // ROWLOCK, UPDLOCK, READPAST
Help with stored procedure syntax please