SQL Server Performance Forum – Threads Archive
Alert For Replication ConflictsHi, 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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.