I have Merge Replication setup between the server and a handfull of
tablets. All of the tables are setup identically; however, one table
has stopped merging. When an update is made on the disconnected
subscriber, and replication occurs the data is replicated to the server
but removed from the tablet. this occurs for all subscribers, and only
for one table. All other tables replicate perfectly.
I am using SQL Server 2000 SP4 and MSDE on the Tablets.
Are there any filters on the table, or joins, which distinguish it from the
other tables?
Cheers,
Paul Ibison
<salois@.gmail.com> wrote in message
news:1133978551.599854.154420@.g14g2000cwa.googlegr oups.com...
>I have Merge Replication setup between the server and a handfull of
> tablets. All of the tables are setup identically; however, one table
> has stopped merging. When an update is made on the disconnected
> subscriber, and replication occurs the data is replicated to the server
> but removed from the tablet. this occurs for all subscribers, and only
> for one table. All other tables replicate perfectly.
> I am using SQL Server 2000 SP4 and MSDE on the Tablets.
>
|||No Joins or relationships either
|||It sounds a bit like compensating changes
(http://support.microsoft.com/default...&Product=sql2k)
but what confuses me is that you say the change can be replicated centrally
ie it remains there. Hopefully I have misunderstood you and it can't be
commited at the publisher, in which case the above link will explain it. If
this isn't it, and there are no filters or joins, then are there any messages
from the merge agent or the conflict viewer that give more info?
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