Simple solution for regular checking of replication subscriptions based on querying system tables on distribution server. Require Database Mail to notify you everytime some subscription is not running ...

BANGALORE, INDIA: With enterprises growing larger each day, it has become customary for most of them to distribute their databases across locations. For instance, a national level company might wish ...