SqlAnswersMail

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

SqlAnswersMail  Review

SqlAnswersMail 3.1.5 Overview 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, Excel, RTF 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. SqlAnswersMail can load a web page from a URL and then use the content of this page as the HTML body of a message. A DBA can further specify whether to embed images, stylesheets and scripts or to resolve all SRC and HREF attributes to an absolute form, so a message can be displayed on any workstation that has access to the Internet.