We have managed to get SQL Server 2008 merge replication working. However, it will occasionally fail for inexplicable reasons (currently, it's because of MSSQL_REPL-2147201021.) When this happens, our data does not get replicated for days! Our admins needs alerted when that is the case.
So, the question is: how can we be alerted when SQL Server 2008 replication fails for any reason. I also am worried about signal vs. noise. I just want to know when my data is not being synchronized and the error number that is causing the problem.
Thanks in advance for any help!