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
'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.