Friday, March 23, 2012

Merg replication - data from subscriber is not updated at publisher

Hi,
I try to set Merg replication.
no data that is changed on the subscriber is updated at the publisher.
The updated/new data is removed from the subscriber and he return to
present the publisher data.
I checked scurity issus can find somthing.
Thanks in advance.
Yohai
Yohai,
this sounds like a compensating changes issue. Please have a look at
http://support.microsoft.com/default...&Product=sql2k
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks for the answer.
I didnt mention that we are using MS-SQL 2000 SP4.
does the patch mention on the article is included in this SP ?
Yohai
|||Yes - you have the option to control this process in sp4 (see
http://www.replicationanswers.com/sp4.asp).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment