AlizaN
asked on
Row handle referred to a deleted row or a row marked for deletion.
HI, I am working with linked servers and getting the error "Row handle referred to a deleted row or a row marked for deletion." Actually, the full error is
OLE DB provider "SQLNCLI10" for linked server "..." returned message "Row handle referred to a deleted row or a row marked for deletion.". [SQLSTATE 01000] (Error 7412). The step failed.
So my destination server is failing with that error. The step it's failing on is a stored procedure on the "source" server that carries out many updates , inserts and deletes on the destination server. I am not getting this error all the time but often enough. What does this error mean and how can I resolve it?
Thank you.
OLE DB provider "SQLNCLI10" for linked server "..." returned message "Row handle referred to a deleted row or a row marked for deletion.". [SQLSTATE 01000] (Error 7412). The step failed.
So my destination server is failing with that error. The step it's failing on is a stored procedure on the "source" server that carries out many updates , inserts and deletes on the destination server. I am not getting this error all the time but often enough. What does this error mean and how can I resolve it?
Thank you.
Need to check the dependent triggers or function on the tables
ASKER
Check them for what?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.