Merge Replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Merge Replication

Merge Replication

Rate Topic

Display Mode

Topic Options

Author

Message

anj.a

Posted Saturday, February 09, 2013 11:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 25, 2013 3:00 AM
Points: 1, Visits: 32

In my environment, there is a merge replication configured . In one database three merge replications is configured.
The database has xml datatype, hence we split into 3 merge replications.
The merge replication is not getting completed by evening.
I got the requirement that , I need to notify the team at subscriber location by mail that merge replication is complete and there is no pending transactions .
Is there any script with which I can know merge replication is complete.
I am thinking of creating a sql job which will send notifications when the replication is complete.
To start with, I thought of using memerge_sessions and msmerge_genhistory with the runstatus column.

Can someone help me with the scripts if you have.

Post #1418081

« Prev Topic | Next Topic »

Permissions