Unanswered: Replication Conflict Auto Notification (How)
I'm Running SQL 2k - Mainly Merge Replication.
Can Someone point me in the right direction on how best to Alert myself/Operator via email when a conflict occurs.
I use xp_sendmail regularly so can deal with that part
I've tried looking for a solution but with no success.
Having to keep opening the Conflict Viewer to check is becomming a Bit Tiresome.
The Only way I can think of is running a batch Job to look at the rowcount of conflict tables (Possibly using a cursor and dynamically built Select Count(*) statements from sysobjects to get conflict table names).
If Conflicts are flagged in the system Replication tables query them but I don't know which table if any exist.
Theres gotta be an easier way - I must be missing something
Any Help Greatly appreciated
"Everything should be made as simple as possible, but not simpler." - Albert Einstein
"Everything should be made as complex as possible, so I look Cleverer." - Application Developer