Microsoft Replication Conflict Viewer (Transactional Replication)

  • Article

The Replication Conflict Viewer enables you to view conflicts that have occurred during synchronization for peer-to-peer transactional replication and transactional replication with queued updating subscriptions. For more information, see View Data Conflicts for Transactional Publications (SQL Server Management Studio).

Note

The Replication Conflict Viewer displays conflicts that occur in merge replication and in transactional replication. For transactional replication, you can use Replication Conflict Viewer to view conflict data, but you cannot choose a different resolution for the conflict.

Options

The Replication Conflict Viewer is divided into two sections. The upper section of the dialog box shows the conflict list for the selected table. When you click an item in the conflict list, the details of the conflict are displayed in the lower section of the dialog box.

The conflict data in the lower section is displayed in two corresponding columns (Conflict Winner and Conflict Loser). 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 Replication Conflict Viewer displays a message in one of the columns, indicating the row was deleted at one location and updated at another. It also indicates the suggested resolution.

  • Database
    Choose a database that includes publications with conflicts.

  • Publication
    Choose a publication that includes tables with conflicts.

  • Table
    Choose a table that includes conflicts.

  • Define Filter
    Click to open the Define Filters dialog box.

  • Apply or Remove Filter
    Click to apply or remove a filter that has been defined in the Define Filters dialog box.

  • Select All
    Click to select all conflicts listed in the grid.

  • Select None
    Click to deselect all conflicts listed in the grid.

  • Remove
    Click to remove selected conflicts from the viewer and their associated metadata from the replication system tables.

  • Show all columns
    Select to show all columns of the table.

  • Show first five columns and other columns with conflicting data
    Select to display the first five columns and any columns that have conflicts. This is helpful when the table has a large number of columns, but you want to see only the columns most relevant to resolving the conflict. The first five columns are always included in this view, as fields that identify a row, such as the primary key or name fields, are often among the first columns of the table.

  • Display Column Information (…)
    Click to view column information: Table Name, Column Name, Data Type, and Column Value.

  • Log the details of the conflict
    Check this box to log the details of the conflict to a file. To specify a location for the file, point to the View menu and click Options. Enter a value, or click the browse (...) and navigate to the appropriate file. Click OK to exit the Options dialog box.

See Also

Tasks

View Data Conflicts for Transactional Publications (SQL Server Management Studio)

Concepts

Conflict Detection in Peer-to-Peer Replication