Export (0) Print
Expand All

Microsoft Replication Interactive Resolver

SQL Server 2000

The Interactive Resolver allows you to view, compare, edit, and select the outcome data. Data that cannot be edited in the Interactive Resolver (for example, rowguid data) is displayed read-only with the box shaded. Information describing why the conflict occurred (for example, the same row was updated at both the Publisher and the Subscriber) is displayed in the Reason for conflict box.

The conflict data is displayed in two corresponding columns (Show and Show or edit for resolution), with the Subscriber data displayed in the left column beneath Show, and the suggested resolution data displayed in the right column beneath Show or edit for resolution. The Resolve With This Data button always refers to the data displayed in the right column.

If the conflict is between updated and deleted data, there may be no data to show for the deleted side of the conflict. In this case, the Interactive Resolver displays a message in one of the columns, indicating the row was deleted at one location and updated at another, and indicating the suggested resolution (conflict winner).

Options

Reason for conflict

View the reason for the conflict including where data modifications ocurred.

Show only columns with conflicts

Select to display only those columns where data modifications conflict.

Show all columns

Select to show all columns regardless of whether there is a conflict or not.

Show

Select Publisher Data or Subscriber Data to view the data modifications made by the winner or loser that caused the conflict. The starting selection in the Show dropdown is based on comparing the Publisher data to the Suggested Resolution. If the rows are different, the Publisher data is displayed. If the rows are the same, the Subscriber data is displayed.

Show or edit for resolution

Select Publisher Data, Subscriber Data or Suggested Resolution to view or edit the data modifications made by the Publisher, the Subscriber or to view or edit the suggested resolution of the Interactive Resolver.

Resolve with this data

Select to resolve the conflict with the data listed. This data will be accepted and propagated to the other servers in the replication topology.

Resolve with defaults

Postpones any resolution to the conflict and closes the Replication Conflict Viewer for this table.

Resolve all with defaults

Postpones any resolution to the conflict and closes the Replication Conflict Viewer for this table.

Log the details of the conflict for later reference

Logs the details of the conflict in system tables.

See Also
Interactive Resolver

Merge Replication Conflict Detection and Resolution

Show:
© 2014 Microsoft