tailieunhanh - Microsoft Press Configuring sql server 2005 môn 70 - 431 phần 9

Bạn khởi chạy System Monitor từ menu Start bằng cách chọn hiệu suất trong menu Administrative Tools trên bất kỳ máy tính chạy Windows. 2. Bạn sử dụng System Monitor để thu thập các dữ liệu số liên quan đến hệ thống khác nhau và các số liệu ứng dụng. | 748 Chapter 19 Managing Replication process. If the agent encounters a conflict it uses a conflict resolver to determine the data that will be propagated to all participants. A conflict resolver is either a Microsoft .NET Framework business component that uses the business logic handler framework included in the namespace or a COM-based object that implements the ICustomResolver COM interface. These components are used to resolve merge replication conflicts. SQL Server 2005 provides 12 COM-based resolvers which Table 19-3 describes. Table 19-3 SQL Server 2005 Conflict Resolvers Name Description Additive Winner determined from the priority value. Specified column set to the sum of the source and the destination column values. Averaging Winner is determined from the priority value. Specified column set to the average of the source and the destination column values. DATETIME Earlier Wins Column with the earlier datetime value determines the winner. DATETIME Later Wins Column with the later datetime value determines the winner. Maximum Column with the larger numeric value determines the winner. Minimum Column with the smaller numeric value determines the winner. Merge Text Conflict winner is determined from the priority value. The text columns in conflict are set to the merged value consisting of the common prefix followed by the unique part from the Publisher then by the delimiter and finally by the unique part from the Subscriber. Subscriber Always Wins Subscriber regardless of whether it is the source or destination is the winner. Priority Column Column with the larger numeric value determines the conflict winner. Lesson 4 Configuring Conflict Resolution for Merge Replication 749 Table 19-3 SQL Server 2005 Conflict Resolvers Name Description Upload Only Changes uploaded to the Publisher are accepted changes are not downloaded to the Subscriber. Download Only Changes uploaded to the Publisher are rejected changes .