Home All Groups Group Topic Archive Search About

xp_sendmail only works if mail client is open

Author
15 Sep 2005 5:39 PM
Jim
Running SQL 2000 sp3a on Windows 2003 server. Outlook 2003 sp1
installed. POP3 and IIS SMTP service installed and working (I can send
and receive email)

xp_sendmail runs successfully however mail is only delivered if Outlook
client is open.

Have read:
http://support.microsoft.com/default.aspx?scid=kb;en-us;315886&sd=tech

.... which seems to state that if you are not using exchange then

"You must have the Outlook client open to send outgoing e-mail"

Can this be true?

Workarounds?

Thanks!

Author
15 Sep 2005 5:56 PM
David Portas
A common workaround is:
http://www.sqldev.net/xp/xpsmtp.htm

--
David Portas
SQL Server MVP
--

AddThis Social Bookmark Button