Unanswered: Use Conflict Viewer to restore deleted rows
I have a replicated database using default conflict resolution (SQL
Server service pack 2). If a row gets deleted on the publisher and
changed on one of the subscribers, when the subscriber is synched the
publisher wins and the row is deleted on both (this is as expected).
If I try to use the conflict viewer to override this action (to
restore the row) I get error messages and the row is not restored.
I am trying to use the subscribers (with the conflict viewer) as a
mechanism to restore rows that were inadvertantly deleted on the
I believe what could be happening is that the record to be restored
has an identity column that is no longer in the range of the what is
current on the publisher and so it is not allowed to be added. Is
there a way around this?