...
The conflict id is the number shown in the status bar, the resolution can be one of the following:
IGNORE |
...
skip the transaction | |
RETRY |
...
try again | |
ABORT |
...
abort the apply whole process | |
RESTART |
...
rollback and restart the transaction | |
ROLLBACK |
...
rollbacks the transaction | |
IGNOREALL |
...
The current and future conflicts in the same transaction will be resolved as ignore |
To see the SQL that is causing the conflict, logon to the apply (target database) as the Dbvisit Replicate schema owner (dbvrep) and query table:
DBRSAPPLY_CONFLICT_LOG
This lists all the conflicts encountered, including failing SQL.