SqlAnswersMail - A user-friendly software package for sending email from Microsoft SQL Server

SqlAnswersMail is based on the lightweight SMTP protocol, which provides for a reliable server-side solution that works across intranets as well as the Internet. SqlAnswersMail features a redundant mail server configuration where if a primary mail server fails, the processing is automatically redirected to a backup mail server. This redundant configuration provides for superb uptime.

SqlAnswersMail is compatible with xp_sendmail, and therefore the migration path from xp_sendmail is very short. There is a way to switch from xp_sendmail to SqlAnswersMail without modifying any of the existing SQL code.

SqlAnswersMail supports PDF and HTML output. PDF documents are compressed using the industry-standard Flate compression, which makes it a perfect option for sending large resultsets.

SqlAnswersMail supports queuing and consolidation. For example, if a user gets 50 notifications a workday, SqlAnswersMail can be configured to queue these notifications during the day and then send them out in a single consolidated email after the workday is over.

SqlAnswersMail implements zip compression. A DBA can specify whether to zip each file individually or combine multiple files in a single attachment. A DBA can also password-protect attachments, which provides for another level of security.

The mail-merge feature of SqlAnswersMail allows a developer to designate a query as a mail-merge source and then display the fields from this query anywhere in a message. In general, it’s possible to embed results of a query in any part of a message including body, recipients line, and subject line.