Description: Script is creating objects for monitoring of replication subscriptions health state. Very simple solution for sending you emails when some subsciption is not running or containing warning ...

Microsoft has taken steps to improve the manageability of replication in SQL 2005. The first such change is the new replication monitor, shown in Figure 1. [Click on image for larger view.] Figure 1.

Although using the SQL Server management pack will not rewrite your application or tune your tables, it can help you with monitoring locks, space utilization, backups, and replication.

SQL Server Replication Monitoring Simple solution for regular checking of replication subscriptions based on querying system tables on distribution server. Require Database Mail to notify you ...