Updating between linked servers

[olemma]

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 'SQLOLEDB'.
[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?

Thanks in advance for your help.

 

[olemma]

Anyone...pls help!!!

 

[tlbroadbent]

I've not encountered a similar issue so I'm just guessing at some possible issues.

Is the linked server a SQL Server also? If so, are both Servers on the same version and service pack of SQL Server? Which version of MDAC is loaded on the local server?

Does the table you are attempting to update have a unique index, primary key or a timestamp column? If not, can you add a PK, Unique Index or a timestamp column? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[olemma]

Is the linked server a SQL Server also? Yes, Enterprise Edition.
If so, are both Servers on the same version and service pack of SQL Server? Yes, sp2.
Which version of MDAC is loaded on the local server?
DriverVer=11-6-2001, 2.62.7926.1
FriendlyName=Mdac 2.6 Exception Package
VersionMajor=2
VersionMinor=62

Does the table you are attempting to update have a unique index, primary key or a timestamp column? Yes.
If not, can you add a PK, Unique Index or a timestamp column?