SQL Mail

[amercer]

I'm tired of dealing with the MAPI client to send all of my SQL Server email. I have searched the Internet and so far have not found a suitable replacement with the functionality that I need. I did find a "replacement" dll from opcode.com which uses standard SMTP, but it won't handle attachments, which is critical to my usage, and it doesn't utilize the same params that xp_sendmail uses. The only reason I would replace the xp_sendmail is that I heavily utilize the scheduling and maintenance plans built into SQL that call the xp_sendmail for their email alerts.

I need to know if there is anyone out there who has taken the radical step of replacing their xp_sendmail Extended Stored Proc with another dll (calling it xp_sendmail and using all the same parameters) that uses SMTP Mail (instead of MAPI) with the mime encoding to handle attachments?

I'm just trying to save myself some time and effort, and would probably be willing to purchase this snippet of code if the price was right.

Thanks,
Adam

 

[tlbroadbent]

We use xp_sendmail quite successfully but I understand that it has a number of shortcomings. I haven't seen any replacement for xp_sendmail. However, I just read an article
about using SMTP to send mail from SQL Server.

http://www.sqlteam.com/item.asp?ItemID=5003

In a followup article, Merkin describes "Building a Mail Queue System" with SQL Server and VB Scripting.

http://www.sqlteam.com/item.asp?ItemID=5908

I don't know if either article will meet your needs but you might get some useful ideas. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.