SQLTeam.com | Weblogs | Forums

Merge Replication

sql2008r2

#1

Hi,
Recently i planing to setup replication monitoring for our merge replication but found some abnormality.
I am running below query to get merge replication data at my distribution database;

SELECT * FROM
OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;',
'set fmtonly off EXEC distribution1CARSEMERP..sp_replmonitorhelpsubscription @publisher = NULL ,@publication_type = 2')

But it does not return any results.
If i use @publication_type= 1 which refer to transactional publication got output.
Please help toadvise.