Hi NG,

I'm looking for Useful Replication Alerts.

I've found:

error:

2601
Cannot insert duplicate key row in object with unique index.
2627
Violation of constraints. Cannot insert duplicate key in an object.
20598
The row was not found at the Subscriber when applying the replicated
command.

other:

3040
4215
8193
14151
14157
20536


are there any other useful error numbers?

Thanks Thomas

Thomas,
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.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com

(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)