Replication Conflict Notification

Is there a way I can be notified when a merge replication resolves/shows a
conflict. Maybe e-mail or something?
Thanks,
Steve
There is interactive conflict resolution. You could also have a job which
will run and query the conflict tables, or place triggers on the conflict
tables
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:9BA89624-D1FA-4C6D-90ED-13FA51D4F5F4@.microsoft.com...
> Is there a way I can be notified when a merge replication resolves/shows a
> conflict. Maybe e-mail or something?
> Thanks,
> Steve
|||Thanks Hilary,
When do the rows from the conflict tables get deleted? Ours are always
empty. We do have the snapshot agent running every night, is that doing it?
Thanks,
Steve
"Hilary Cotter" wrote:

> There is interactive conflict resolution. You could also have a job which
> will run and query the conflict tables, or place triggers on the conflict
> tables
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
> news:9BA89624-D1FA-4C6D-90ED-13FA51D4F5F4@.microsoft.com...
>
>
|||IIRC they are purged when the history retention period has passed.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SteveInBeloit" <SteveInBeloit@.discussions.microsoft.com> wrote in message
news:2BB8DB35-8636-4EFD-868F-0A9BBA4AFB00@.microsoft.com...[vbcol=seagreen]
> Thanks Hilary,
> When do the rows from the conflict tables get deleted? Ours are always
> empty. We do have the snapshot agent running every night, is that doing
> it?
> Thanks,
> Steve
> "Hilary Cotter" wrote:

Replication Conflict Auto Notification (How)

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