Groups | Blog | Home
all groups > sql server replication > march 2005 >

sql server replication : spBrowseMergeChanges shows records but no data needs to be merged HELP


Darin
3/31/2005 7:45:52 PM
I ran spBrowseMergeChanges from www.replicationanswers.com for one
particualr table that I Know a lot has occured on. It shows a result set
of 6,469,634 rows. BUT, the enterprise manager is showing "No Data needs
to be merged".

Help. This isn't the only table that has this problem. I looked at
others and they have issues also.
There are no Red X's on anything. It just seems no data is going to be
merged even though it is in the tables to be merged.

HELP.

Darin

Paul Ibison
4/1/2005 8:10:44 PM
Darin,
it's possible of course that the stored procedure is faulty in some way -
it's only in beta1 :)
I know I don't need to ask this, but if not already done, can you manually
start the merge agent.
Also, can you enter a dummy record on the publisher, check that the total of
spBrowseMergeChanges has incremented by one, run the merge agent and look
for the record on the subscriber.TIA,
Paul Ibison

AddThis Social Bookmark Button