Groups | Blog | Home
all groups > sql server replication > march 2005 >

sql server replication : Notify Error in replication


ishaan99 via SQLMonster.com
3/4/2005 4:17:39 PM
I have a cluster set up where in xp_sendmail doesnt work. I also dont have
an SMTP set up to use xp_smtp_sendmail. Is there any other way that i can
send emails to notify users if anything failed on replication. any help
will be greatly appreciated.
TIA

--
Paul Ibison
3/4/2005 6:27:58 PM
You could use NET SEND, but I wouldn'd advise it as a reliable solution,
given that computernames and usernames change over time. You could poll the
server from one that does have email capability and create a notification
solution this way. I'd probably do neither and push to have the SMTP set up.
Rgds,
Paul Ibison

AddThis Social Bookmark Button