Hi, Our application involves replication process to replicate some tables to other database. We are using Transactional Replication method for this by applying snapshot. my concern is I want to access exact record that is being replicated to subscriber in case of failure. i.e. when replication fails, i want to return back the current record to the publisher from the subscribr or distributor. I have studied some of the replication tables present in system databases like msreplalerts, msrepl_errors, msrepl_transactions etc. but could not find useful info for how to access exact record from current job. Can anyone help in this regard. How i can get actual data from subscriber/distributor when replication fails. Because I want to change status for that record accordingly in the publisher database. Is ther any other way to achieve this? Also how using RMO from code can help me for this? can anyone give any sample code?? please suggest ASAP.