Friday, 24 February 2012

Conflict resolution logs

Is conflict resolution data stored somewhere? For example: If you resolve a
conflict and choose not to have the logs mailed to you. Is there a way to go
back and see what record it was that had the conflict?
TIA
Paul Bauer
Paul,
look for a table whose name starts with 'conflict' and ends with the
article's 'tablename'. This table has the same structure as the table on
which it is based and is stored at the Publisher for applications that use
centralized conflict logging, and at the Subscriber for applications that
use decentralized conflict logging. Another conflict table generated during
merge replication setup is MSmerge_delete_conflicts. The table is a log for
deleted conflicts. It contains information for deleted rows that conflicted
with an update and lost the conflict, or because a delete was undone to
achieve data convergence.
You can look at these tables directly or use the conflict viewer.
HTH,
Paul Ibison
|||Paul,
This table contains no data. I believe this is because the conflict has been
resolved. Is there another place where the resolution of the conflict is
stored?
Paul
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OX5LN7OhEHA.244@.TK2MSFTNGP10.phx.gbl...
> Paul,
> look for a table whose name starts with 'conflict' and ends with the
> article's 'tablename'. This table has the same structure as the table on
> which it is based and is stored at the Publisher for applications that use
> centralized conflict logging, and at the Subscriber for applications that
> use decentralized conflict logging. Another conflict table generated
> during
> merge replication setup is MSmerge_delete_conflicts. The table is a log
> for
> deleted conflicts. It contains information for deleted rows that
> conflicted
> with an update and lost the conflict, or because a delete was undone to
> achieve data convergence.
> You can look at these tables directly or use the conflict viewer.
> HTH,
> Paul Ibison
>
|||Paul,
resolved conflicts still go into these tables for the conflict viewer. There
are no other tables apart from if you are doing some custom logging (custom
conflict resolution).
HTH,
Paul Ibison

No comments:

Post a Comment