Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fazle_rabbee
Yak Posting Veteran
63 Posts |
 Posted - 2012-04-04 : 05:04:57
|
| I have got an original SQL 2008 R2 publisher and some Original SQL 2008 R2 Subscriber. I set up merge Replication among the servers. The Problem is Conflicts are coming from servers in a regular basis as no transactions were made in both publisher and subscriber. What should I do to Get rid of this kind of issue. looking to hereing from you.fazle rabbee |
|
|
SQLSoldier
Master of MCMs
9 Posts |
Posted - 2012-04-05 : 20:30:52
|
| Look at Clonflict Viewer and see what the nature of the conflicts are. If you are tracking conflicts at the row level instead of column level, you may want to consider changing that. Column-level tracking will merge changes as long as they are to different colimns. This does require tracking more data and workign a little harder, but it can help resolve a lot of conflicts in certain cases.You may also want to consider changing the default conflict resolution method.Robert L DavisMicrosoft Certified Master: SQL Server 2008Sr. Product Consultant and Chief SQL EvangelistIdera |
 |
|
|
|
|
|
SQL 2008 R2 Merge Replication Conflict Problem