No, it doesnt need Exhange. The SQL Mail service provided with SQL Server uses a MAPI profile on the server. This is limited in that it ties you to one profile and requires you to have a mail client like Outlook installed on your server.
This doesn't help you much if you want to be able to send from different addresses, or if you are unable to set up a MAPI profile on the server. There are alternatives. There are a few stored procedures for calling and using COM Components. The sp_SMTPMail procedure calls the ASP Mail COM object from www.serverobjects.com to send an email. This is easily modifiable to use any mail component. JMail from tech.dimac.net is another good one that I use, but ASP Mail is alledgedly better. Neil -----Original Message----- From: Bob Pagett [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 11:18 To: cf_list Subject: [ cf-dev ] OT: Mailing from SQL Server Does SQL Server require Exchange to send mail? I'm not familiar with Exchange, and can't work out if it is or isn't a requirement. TIA Bob -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
