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 linkhttp://www.databasejournal.com/features/mssql/article.php/1438231 about setting up the alerts. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>