Hi
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).
or
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
thx
GWCheck Lumigent (http://www.lumigent.com) website for latest tool on notification and its free.|||Cool
thx again Satya
GW
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment