Initial snapshot not ready, can I list these subscriptions?


  • Hi,

    I am creating a procedure that monitors my replication subscriptions and sends out emails if something is wrong. We have ~150 (transactional replication) subscriptions so manual monitoring is a pain.

    I found a useful procedure that helps,  sp_replmonitorhelpsubscription. My problem is that I can't filter out subscriptions with the following status: "The initial snapshot for publication 'xxx' is not yet available."

    Any way I can list these subscriptions with sql or some nice procedures?


    Monday, March 31, 2014 9:43 AM

All replies