Groups | Blog | Home
all groups > sql server replication > july 2004 >

sql server replication : Indicating the end of replication


jane201315 NO[at]SPAM yahoo.com
7/28/2004 1:05:21 PM
Hi,
Is there a way one can tell when the Merge Replication between the
publisher and subscriber is done completely? Because, when replicating
large tables, it does take considerable amount of time, and I want to
somehow ensure that the replication is completed before disconnecting
the subscriber.

I appreciate any help in this regard!

Thanks!
Paul Ibison
7/29/2004 9:19:54 AM
Jane,
if you're using the the activeX controls, they have a status event.
You could use the On Success action of the Run agent step of the merge job.
Alternatively you could check the latest record for this agent in
MSmerge_history (if you're not in continuous mode, you should get the
message 'No data needed to be merged.' at some time).
HTH,
Paul Ibison

AddThis Social Bookmark Button