sql server new users: EMAIL SQL -- sql server new users

EMAIL SQL

Tom
11/29/2004 8:21:02 AM

sql server new users:

Hello
I have several w2k3 ent servers running sql2k. They all replicate to a main
server which is working great. What i would like to do is have the main
server page me or email me when an error accurs with the replication. Is this
possible? Thanks for any insight!
--
TC

Re: EMAIL SQL

Keith Kratochvil
11/29/2004 10:26:01 AM

The easiest solution is to use SMTP mail. It is easy to set up and it is
very reliable.

XPSMTP.DLL - SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm

The other option is to use xp_sendmail (built into SQL Server -- kind of).
http://support.microsoft.com/?kbid=870675

--
Keith

[quoted text, click to view]

Re: EMAIL SQL

Keith Kratochvil
11/29/2004 10:27:01 AM

Here is a FAQ regarding SQL Mail
http://support.microsoft.com/kb/311231/EN-US/

--
Keith

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.