Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). From xp_sendmail to xp_smtp_sendmail   Article Abstract: (Bill Wunder) Builing upon the asynchronous safe_sendmail email notification system presented in the article, "From xp_sendmail to safe_sendmail", this article takes you through the steps necessary to replace xp_sendmail with a freely available smtp based dynamic linked library.   Read this article...

Related Articles - For Members. All Articles By Author Take My SQLMail, Please! Troubleshooting SQL Mail Procedures From xp_sendmail to safe_sendmail SMTP Mail with .NET (1.1, 2.0, and differences explained) From SQLMail to SMTP in the SQLAgent Maximize Your Use of DTS Packages How to Wrap xp_sendmail Building a Mail Queue System

RE: From xp_sendmail to xp_smtp_sendmail
(posted: 3/18/2005 7:35:15 AM)
I was unable to find any other way to append procedure results into the body of an email - this works wonderfully. I do have 1 question, though. I run this on several srvs successfully. I moved it to a new srv yesterday - same code across the board - my emails, however, are each prepended with NULL. All results are in the mail, but there's a NULL at the top of each email before the resultstring. SET NOCOUNT ON is in every proc. What is causing this?