I'm trying to setup up SQL Mail on a hosted server that is in a workgroup and not a domain. I want to be able to send mail from a stored procedure. I have Mail Enable up and running (It's a mail server). Any ideas on how I can get SQL mail configured? I don't want use Exchange, I want to use internet mail.
Edited by - etgibbs on 04/09/2003 2:13:46 PM
The configuration to use Internet Mail as your mail vehicle does come with 1 severe caveat: in tests I've done, the server needs to be logged onto and running Outlook (I dunno about any other MAPI-compliant software would also work tho) and the "send/receive" option set at a frequent pace (U decide on the frequency), otherwise, your e-mails will just sit there looking pretty. The MAPI profile will appear in the SEM SQLMail properties drop-down list (and SQL Server Agent). It does work, but is it what U want....