sql server replication: I have two machines, both running Windows Server 2000 with SP4 and SQL
2000 - 8.00.760

I have identical database being replicated, using push merge replication.
One of the machine act as the publisher and distributor, and the other as the
subscriber.

Initial snapshot is working properly with no errors.

Push merge replication is working, with no errors. When we check the
records, only the existing records that have been updated or edited was being
replicated. New data (or records) from the publisher and subscriber are not
being
replicated on both server.

Hope anyone could help me on this.
Am I missing something? Where?


Help Please!!

Roland

I have seen this happen in 2 circumstances:
(1) Firstly when the filter was set to 1=2 and inserts
were made while the merge agent was running

(2) If you bulk insert the rows and choose the defaults,
then FIRE_TRIGGERS is false and consequently the rows are
not added to MSmerge_contents.

In either case, you need to run sp_addtabletocontents to
include the rows then resynchronise. Alternatively you
can use sp_mergedummyupdate for a single row.
rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul,

Thanks for the answer, I would give it a try.
Hope it will solve my problem.

Thanks again, and more power.

Roland




[quoted text, click to view]