Posted by David Portas on 10/07/12 11:27

SMTP is a standard protocol for email. Most mail servers will support SMTP
so if you are on a corporate network you probably already have access to
ne - ask whoever manages your mail server.

If you don't already have one then you can set up IIS as an SMTP server.
This is not something I'm an expert on but here's a link about it:
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/e4cf06f5-9a36-474b-ba78-3f287a2b88f2.mspx

One point about xp_smtp_sendmail is that it requires the server to be setup
for sending mail without authentication. For that reason you probably won't
be able to use your ISP's email server.

--
David Portas
SQL Server MVP
--

[Back to original message]