Alert For Replication Conflicts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Alert For Replication Conflicts

Hi, i have published tables with ID-Seeds columns as PK(Not For Replication). Conflicts occur often when the subscriber has the same new ID that already exists at the Publisher. I need to set an alert when a replication-conflict occurs rather that to check for conflicts manually. How can i accomplish this? I couldn’t find the particular error-message to trap in an alert.
Replication Monitor and the SQL Server Agent provide a powerful mechanism for setting up lights-out management for a replication environment. SQL Server Agent monitors the NT application log, watching for an event that qualifies as one of the defined alerts. Refer to this link about setting up the alerts. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.