Whenever I run a query similar to this one trying to update a table in another server:
update serverxyx.dbxyz.dbo.tablexyz set field2xyz=1 where field2xyz=abc
I get this error:
Server: Msg 7346, Level 16, State 2, Line 1
Could not get the data of the row from the OLE DB provider 'SQEDB'.
[OLE/DB provider returned message: Row handle referred to a deleted row or a row marked for deletion.]
Has anyone come up with this before? Is there any workaround? Or what am I doing wrong?
Not really an answer, but just beware. I've had some severe problems doing Deletes and Updates across a linked server.
Selects and inserts always work great, but after I've gotten everything going it takes MINUTES to delete or update a record. It eventually works but it is slow as a dog. Never really found an answer why, but it has happened to me several times.