SqlAnswersMail Review

Recommended: Click here to improve PC speed »

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.

Microsoft SQL Server 2000 or later

Please contact SqlAnswersMail publisher, SqlAnswers.com if you have questions or issues regarding this product.

Awful

Poor

Average

Good

Excelent