SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQLAnswers Review


SQLAnswers Review

Author
Message
Hugh Scott
Hugh Scott
Right there with Babe
Right there with Babe (718 reputation)Right there with Babe (718 reputation)Right there with Babe (718 reputation)Right there with Babe (718 reputation)Right there with Babe (718 reputation)Right there with Babe (718 reputation)Right there with Babe (718 reputation)Right there with Babe (718 reputation)

Group: General Forum Members
Points: 718 Visits: 190
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/hscott/sqlanswersreview.asp



Henrik Staun Poulsen-237657
Henrik Staun Poulsen-237657
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 16

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


Dale Corey
Dale Corey
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3015 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
Tatsu
Tatsu
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3168 Visits: 307
How does this compare to reporting services?

Bryant E. Byrd, BSSE MCDBA MCAD
Business Intelligence Administrator
MSBI Administration Blog
fhanlon
fhanlon
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6218 Visits: 2333

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
Evgueni Tsygankov
Evgueni Tsygankov
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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


Henrik Staun Poulsen-237657
Henrik Staun Poulsen-237657
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 16

Hi Evgueni,

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

Henrik


mannadba
mannadba
Old Hand
Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)

Group: General Forum Members
Points: 335 Visits: 275
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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search