Useful Replication Alerts - 11-03-2004 , 07:06 AM
I'm looking for Useful Replication Alerts.
Cannot insert duplicate key row in object with unique index.
Violation of constraints. Cannot insert duplicate key in an object.
The row was not found at the Subscriber when applying the replicated
are there any other useful error numbers?
Useful Replication Alerts - 11-03-2004 , 08:47 AM
the inbuilt alert which monitors for error
14151 "Replication: Agent Failure" should cover all these?
In my case we have only SMTP, so I have an additional
step in the distribution agent which sends an email, and
the workflow points to this step on failure or success of
step 3. This alerts me on any such failure.
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: