Friday, 24 February 2012

Conflict table Problem

Hi All,

I Want to know the following

1) when are the conflict tables in Merge replication created and are they dropped automatically after certain duration or do they exists once created?

2) data for how many days exist on the conflict tables.

Lindly reply even for one question its very urgent for me

Thanks in advance to all u helpfull people out there

1. MSmerge_conflicts_info table is created when you create the publication. The conflict tables for each article are created in the publication database, subscription database, or both (the default), depending on the value specified for the @.conflict_logging parameter of sp_addmergepublication. Each conflict table has the same structure as the article on which it is based, with the addition of the origin_datasource_id column. The Merge Agent deletes data from the conflict table if it is older than the conflict retention period for the publication, which is specified using the @.conflict_retention parameter of sp_addmergepublication (the default is 14 days).

2. The Merge Agent deletes data from the conflict table if it is older than the conflict retention period for the publication, which is specified using the @.conflict_retention parameter of sp_addmergepublication (the default is 14 days).

hope that helps

No comments:

Post a Comment