all groups > sql server replication > january 2005 >
You're in the

sql server replication

group:

Any alert system for Merge Replication Conflicts???


Any alert system for Merge Replication Conflicts??? Paul Ibison
1/14/2005 6:48:48 AM
sql server replication: Not as far as I know.
I have a similar situation at one of our managed service
providers who won't allow us to set up alerts. In this
case I use a polling solution.
You probably know this anyway, but you would set up a job
to poll the conflicts table and send an email
(xp_sendmail if you're lucky enough to have MAPI
integration, or the SMTP equivalent otherwise). This can
be set up quite nicely, and you can attach the contents
of the conflicts table if you do a bit of extra work.
After that, you just schedule the job to run every few
minutes.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Any alert system for Merge Replication Conflicts??? Chai
1/14/2005 8:19:14 AM
Hello:

Is there a way to set up an alert to DBA (via email and such) when merge
replication encounters conflicts (so DBA doesn't have to check it manually
via Enterprise Manager)?

Thank you.


Chai W.

AddThis Social Bookmark Button