Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLAnswers Review Expand / Collapse
Author
Message
Posted Monday, September 19, 2005 12:25 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 3, 2014 7:35 PM
Points: 401, Visits: 166
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/hscott/sqlanswersreview.asp


Post #221260
Posted Thursday, September 22, 2005 2:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, February 25, 2013 6:45 AM
Points: 70, Visits: 15

We use a program called Blat.exe, which is free, and can be found at www.blat.net

I call it from xp_cmdshell, and it works great.

Best regards

Henrik Staun Poulsen

Stovi Software, Denmark

 

Post #222503
Posted Thursday, September 22, 2005 6:03 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4

...and what happens to this product when everyone realizes that Database Mail is SMTP based in 2005?  Hmmm, invest in this or sock the money away for SQL Server 2005?




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
Post #222559
Posted Thursday, September 22, 2005 6:47 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 7, 2014 12:50 PM
Points: 292, Visits: 264
How does this compare to reporting services?

Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
Post #222575
Posted Thursday, September 22, 2005 7:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:51 AM
Points: 2,180, Visits: 1,962

I just use Microsoft CDOSys.  No 3rd party tool.  It's part of Windows and works great.  See any of the sample TSQL scripts or articles on this site.





Francis
Post #222618
Posted Monday, September 26, 2005 4:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 21, 2007 11:57 PM
Points: 1, Visits: 1

Hello,

My name is Evgueni Tsygankov. I am the developer behind SqlAnswersMail. I just wanted to say that appreciate your feedback, and I wanted to address the issues raised in this thread:

- Blat.exe seems to be a good SMTP tool, but the main difference is that it doesn't support sending results of a SQL query. Also, since SqlAnswersMail runs as an out-of-process exe you can use DCOM to secure its permissions, which can be a great plus when running on “public” SQL Servers. The same applies to CDOSys -- no query results generation and lack of security. The "meat and potatoes" of SqlAnswersMail is in its ability to generate output in PDF and HTML formats straight from SQL queries.

- Database Mail in 2005. This comment is right on the money. Microsoft came out with this addition in the July Community Preview. The functionality is very similar to SqlAnswersMail. The two things I can say are better in SqlAnswersMail is that it's 99% compliant with xp_sendmail (Database Mail will require a migration) and SqlAnswersMail supports PDF generation from SQL.

- SqlAnswersMail is a quick way of sending well-formatted email from SQL Server. It's easy to setup, configure and use. Reporting Services is a great tool but it's designed to email reports, which means more work -- these reports need to be designed, developed, tested, deployed, etc.

Evgueni Tsygankov
www.sqlanswers.com

 

Post #223748
Posted Tuesday, September 27, 2005 1:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, February 25, 2013 6:45 AM
Points: 70, Visits: 15

Hi Evgueni,

The Out-of-process feature is indeed a major difference.  PDFs as well. Thanks for spelling it out clearly.

Henrik

 

Post #223800
Posted Tuesday, April 25, 2006 10:22 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 4:24 PM
Points: 57, Visits: 230
Database Mail in 2005 is also very weak in formatting the results of a query sent via email. Basically, you get pure text only. If you want to actually transmit structured information or have your emails look pretty, you have to manually massage the query output to make it happen.

Also, aside from the HTML which Database Mail only partially supports (it doesn't make HTML; it just sets the emails content-type), and the PDF format which has already been mentioned, SQLAnswersMail supports a number of other formats, such as Excel and Word. It also has a variety of automation tools which can save development time such as combining multiple emails together and compressing attachments in ZIP format (with optional password).

Another feature is the ability to send web pages in the email. I don't mean HTML-formatted text, I mean actual remotely-retrieved web pages. Thus you can keep your HTML generation OUT of SQL and on the web where it belongs. Although I admin to using it in our environment (since we didn't have SQL Answers at the time), it doesn't seem like best practice to use SQL to cobble together an HTML document.



Post #275271
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse