How to: View Data Conflicts for Transactional Publications with Queued Updating Subscriptions (SQL Server Management Studio)

Conflicts for queued updating subscriptions are resolved based on the resolution option chosen for the publication. For more information, see How to: Set Queued Updating Conflict Resolution Options (SQL Server Management Studio).

View conflicts in the Microsoft Replication Conflict Viewer. Conflict data is available in the Replication Conflict Viewer for the amount of time specified for the conflict retention period (with a default of 14 days). To set the conflict retention period, either:

• Specify a retention value for the @conflict_retention parameter of sp_addpublication (Transact-SQL).
• Specify a value of 'conflict_retention' for the @property parameter and a retention value for the @value parameter of sp_changepublication (Transact-SQL).

To view conflicts

1. Connect to the Publisher in Microsoft SQL Server Management Studio, and then expand the server node.

2. Expand the Replication folder, and then expand the Local Publications folder.

3. Right-click the publication for which you want to view conflicts, and then click View Conflicts.

4. In the Select Conflict Table dialog box, select a database, publication, and table for which to view conflicts.

5. In the Replication Conflict Viewer, you can:

   • Filter rows with the buttons to the right of the upper grid.
   • Select a row in the upper grid to display information on that row in the lower grid.
   • Select one or more rows in the upper grid, and then click Remove, which removes the row from the conflicts metadata table.
   • Click the properties button (…) to view more information on a column involved in a conflict.
   • Select Log the details of this conflict to log conflict data to a file. To specify a location for the file, point to the View menu, and then click Options. Enter a value, or click the browse button (...), and then navigate to the appropriate file. Click OK to close the Options dialog box.

6. Close the Replication Conflict Viewer.

See Also

Concepts

Queued Updating Conflict Detection and Resolution

Help and Information

Getting SQL Server 2005 Assistance