The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P88: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Managing Replication Chapter 9 417 4. In this wizard after the starting page you will be asked about the publisher you want to select. 5. Next you will see the Configure Topology which is the new addition in SQL Server 2008. Right-click the window to add the databases you need to add to the Peer-to-Peer Replication and peer originator id. The peer originator id should be unique across the Peer-to-Peer topology. After configuring Peer-to-Peer Replication in all tables there will be hidden column to store the peer originating id. 6. The beauty of this feature is that in case of an expansion you can add few more nodes to the topology without much trouble. Conflict Resolution In Merge Replication if the row is modified on two or more ends the merge agent will detect this change which is called a conflict. Conflict resolution is based on a set of rules. By default Publisher will win most conflicts. However you have the option of customizing conflict resolution. To configure conflict resolution you need to use the steps in Exercise . EXERCISE Enabling Conflict Resolution 1. Launch Open SQL Server Management Studio from Program Files SQL Server 2008. 2. Supply the correct authentication for you to login to the SQL Server in which you are going to enable conflict resolution. 3. Navigate to Replication node in the SQL Server Management Studio. In the Replication node select Local Publication node and expand it. 4. Right-click the publication you want to configure for conflict resolution and choose Properties from the menu. 5. Select Articles. 6. Click the Article Properties button and select Set properties of Highlighted Table Article. You will be taken to the screen in Figure after you select the Resolver tab. 418 Chapter 9 Managing Replication Figure Conflict Resolvers for Merge Replication A resolver is a module called by the Merge Agent that handles merge conflicts. C Use the default resolver Use a custom resolver registered at the Distributor i .
