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 |
|
roel_vz
Starting Member
16 Posts |
 Posted - 2008-10-09 : 04:29:03
|
| Hi,I'm using SQL Server 2005 and have set up a merge replication between a publisher and 9 subscriber. The problem is that one of the rows in one subscriber that should be synchronized for some reason has a different rowguid then everywhere else.Can I safely update the incorrect rowguid at the subscriber? Will that syncrhonize the rows again? Are there any dangers in doing this?Also, is there a clear reason how something like this can happen? Or is it too difficult to say in general?Thank in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-09 : 09:00:33
|
quote:
Originally posted by roel_vz
Hi,I'm using SQL Server 2005 and have set up a merge replication between a publisher and 9 subscriber. The problem is that one of the rows in one subscriber that should be synchronized for some reason has a different rowguid then everywhere else.Can I safely update the incorrect rowguid at the subscriber? Will that syncrhonize the rows again? Are there any dangers in doing this?Also, is there a clear reason how something like this can happen? Or is it too difficult to say in general?Thank in advance
But are rows been replicated back and forth for that subscriber? I wouldn't touch as Merge replication works by Triggers through RowGuid. |
 |
|
|
|
|
|
Different rowguid between publisher and subscriber