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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-03 : 07:43:24
|
| Vikas Kohli writes "Hi,I am setting up a SQL Server Database Merge Replication between Publisher (P) & Subscriber (S) using EXCHANGE_TYPE '1' (Data only needs to be merged from Subscriber to Publisher - Upload Only). Publisher priority is maximaum by default.However, I am facing this issue:Under normal scenario, if a row of Data is changed at Subscriber, it is updated at the Publisher since there is no change at Publisher (No Conflict).But when same Row of Data in Publication (Table x) is updated at the Publisher and also at the Subscriber (conflict situation), the row do not particicipate in Replication when the agent runs and then it never participates in Replication upon subsequent updats. Means the Data at Subscriber and Publisher remains different for that row. SQL Server do show any conflict that I can resolve. Kindly help me to find out root cause and how to fix this!Operating System : Win2003 (No Service Pack)SQL Server 2000 Service Pack 3a" |
|
|
|
|
|
SQL Server 2000 Merge Replication Problem