September 25, 2008 at 4:59 am
I have set up peer-to-peer replication , now is there any way that i can configure notification mail
whenever a conflict occurs in the replication.
September 29, 2008 at 9:59 am
I do not have any merge replication instances to try this on so this is just a suggestion requiring more research.
According to BOL, SQL Server 2005 creates a table called MSmerge_conflict_info in the publisher and subscription databases. Perhaps you could put a trigger on this table that sends you emails whenever new records are inserted?
BOL also says:
" Replication creates a conflict table for each table in a merge article, with a name in the form MSmerge_conflict_ .
Conflict tables have the same structure as the tables on which they are based. A row in one of these tables consists of the losing version of a conflict row (the winning version of the row is in the actual user table). "
If you don't like the trigger idea (which could result in a lot of emails depending on the volume of conflicts), perhaps you could create a job to look for new conflict tables or new records in the conflict tables to email you.
Chris.
Chris.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply