RE: sp_send_cdosysmail Vs sp_send_dbmail

SSC Guru

Points: 1003894

September 17, 2014 at 3:21 pm

OK... no answer to my question. I'll summarize just by saying that sp_Send_DBMail is support and CDOSYS is no longer supported. That, not withstanding, I almost always use CDOSYS for anything for 2005 and below because CDOSYS will allow you to create your own "From" and sp_Send_DBMail didn't get that feature until 2008. If you need them, there are some features in sp_Send_DBMail that are a little tougher to initially code for, such as the ability to include the result set of a query as an attachment.

So, as with all else with SQL Server, "It Depends". 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)