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
...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?
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.
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 Tsygankovwww.sqlanswers.com
Hi Evgueni,
The Out-of-process feature is indeed a major difference. PDFs as well. Thanks for spelling it out clearly.
Henrik
