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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Publisher always wins eventhough it is not updated

Author  Topic 

rajendranrajashare
Starting Member

2 Posts

Posted - 2010-05-07 : 10:26:20
Hi,

I have a peculiar problem. I have set up Sql Server 2005 merge replication (Push every minute) between two machines.

I have an application that would do CRUD operation on a table. When i update a record in machine2 (Subscriber), iam able to see the change in machine1 ( Publisher) and also vice versa. No issues, replication works perfectly.

But when i try to update a particular record in "Subscriber", while iam viewing same at "Publisher" end, the transaction never succeeds. I can see that the record gets updated in "Subscriber" DB but within a minute (when merge agen runs), an update conflict is raised and info in "publisher" table is updated on the subscriber.But i never updated anything in publisher.

Any clues on why this is happening?

Thanks,

rajendranrajashare
Starting Member

2 Posts

Posted - 2010-05-10 : 00:54:43
Hi,

Pls ignore this post. It is coding issue that we lately identified. Replication works without any issues.

Sorry for the inconvenience caused in this regard.

Thanks
Raja
Go to Top of Page
   

- Advertisement -