sql server replication: We have a replication desing with several publications (merge, unidirectional
merge, and snapshot) synchronizing with several MSDE instances on laptops. On
one of the uniderectional merges one laptop replicated the first time and
received all data (1067 rows). More data was added to the server, but when
the laptop replocated again it only received a fraction of the new data (up
to 1527 now). We reran the snapshot (although this should not matter with a
merge publication), but replicating again did not replicate any more data. We
deleted ALL records on the laptop and replicated with no data sent down this
time. Finally even more data was added at the server (now up to 4060) and
replicated with the laptop again but only received aroung 1500 records. I
cannot see any pattern to the amount of data sent each time and several other
clients have not had this problem. The log for the agent on the server shows
"No Data Needed to Be Merged." for all the time the user replicated and did
not receive the new data (but no errors). The MSDE instances syncrhonize via
an application that uses the replication ActiveX objects called from C#.

Any ideas?

Tommy,
are you using filters at all - dynamic or static?
Do you have a definite case where a row inserted on the
publisher goes to one subscriber and not the other? Cna
you script out the replication subscriptions and compare
the 2 scripts to look for differences.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul,
This paticular publication is not filtered dynamically or statically. As far
as subscriptions, the subscribers are added to the publication via the same
stored procedure and the initiation of the replication process is via the C#
code so it is the same per user also.

Tommy

[quoted text, click to view]