How to: Configure Conflict Detection for Peer-to-Peer Transactional Replication (SQL Server Management Studio)
Peer-to-peer replication includes the option to enable conflict detection across a topology. For more information, see Conflict Detection in Peer-to-Peer Replication.
To use conflict detection, all nodes must be running SQL Server 2008 or a later version; and detection must be enabled for all nodes. If you configure peer-to-peer replication in the Configure Peer-to-Peer Topology Wizard, conflict detection is enabled by default, but you must still specify an originator ID for each node. For more information about how to configure a topology, see How to: Configure Peer-to-Peer Transactional Replication (SQL Server Management Studio).
Note
When you configure peer-to-peer replication, you specify an ID for each node. This ID, which must be unique across all nodes in the topology, is stored in the originator_id column in the MSpeer_originatorid_history system table. If a node is removed from the topology, the ID is still retained in the history table. The ID is retained to prevent false conflicts from occurring if there are changes from the removed node that are still being replicated across the topology. If you want to reuse the ID for a new node, you must first manually delete the ID from the MSpeer_originatorid_history table at all nodes. Before you delete an ID for a node, execute sp_requestpeerresponse to verify that all changes that originated from that node have been replicated.
To specify an originator ID for each node
On the Configure Topology page of the Configure Peer-to-Peer Topology Wizard, right-click the design surface of the page, and then click Add a New Peer Node.
In the Connect to Server dialog box, connect to the server.
In the Add New Peer Node dialog box, select the publication database, and specify a unique value for the node in the Peer ID box. The value must never have been used in the topology. For a list of IDs that have already been used, execute sp_help_peerconflictdetection.
To view the originator ID value for a node
- View the originator ID value on the Subscription Options page of the Publication Properties - <Publication> dialog box. The value is displayed in the Peer originator id field. For more information about how to access this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).
To disable conflict detection
- On the Subscription Options page of the Publication Properties - <Publication> dialog box, select False from the Allow peer-to-peer conflict detection list. For more information about how to access this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).