Solved

Row handle referred to a deleted row or a row marked for deletion.

Posted on 2010-09-01
3
2,214 Views
Last Modified: 2012-06-22
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.
0
Comment
Question by:AlizaN
3 Comments
 
LVL 1

Expert Comment

by:revteam
ID: 33583793
Need to check the dependent triggers or function on the tables
0
 
LVL 1

Author Comment

by:AlizaN
ID: 33586600
Check them for what?
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 37096377
Considering the comments:

"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."

In my opinion the issue you are having is caused by a slow "source" environment and from the little details posted above I suggest to lower the batch size you process in one cycle. Other thing to do at both source and destination - at least UPDATE SATTISTICS table_name for all tables having heavy INSERTs/DELETs and optimize as much as you can the SQL code, add missing (if any) indexes.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL query with cast 38 53
How to search for strings inside db views 4 36
Script to backup a Database Dayli on SQL Server Express 3 19
What is this datetime? 1 19
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question