SQL Server Performance

Alert For Replication Conflicts

Discussion in 'Performance Tuning for SQL Server Replication' started by TALAT, Mar 7, 2004.

  1. TALAT New Member

    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.
  2. satya Moderator

    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.

Share This Page