SQL Server Performance

Need replication to send me a notification when it failes

Discussion in 'Performance Tuning for SQL Server Replication' started by w84me2say, Nov 5, 2007.

  1. w84me2say New Member

    I'm running SQL 2000 sp3a and have replication going from serverA to serverB.
    We have had a few issue with power/network outages, which causes replicaiton to fail.
    Since we are unable to install SQL Mail, does anyone have another way of monitoring replication for failure and alerting themselves with email?
    I'm thinking an "xp" type command?
    Thanks in advance
  2. satya Moderator

Share This Page