This worked for me:

INSERT INTO MyDB.dbo.replStatus

SELECT a.*

FROM OPENROWSET

('SQLNCLI', 'Server=DBServer;Trusted_Connection=yes;',

'SET FMTONLY OFF; exec distribution..sp_replmonitorhelpsubscription

@publisher = DBServer,

@publication_type = 2,

@publication=MyPublication') AS a;

Did you find an answer to this yet? I'm doing something very similar. What I've found out so far is that the proc sp_replmonitorhelpsubscription has an INSERT-EXEC in...