Post reply

sp_send_cdosysmail Vs sp_send_dbmail

  • September 4, 2014 at 12:32 am

    #298979

    Is it advisable to use cdosysmail even in SQL 2008? Or sp_send_dbmail is better?

  • September 4, 2014 at 4:37 pm

    #1743359

    balasach82 (9/4/2014)

    Is it advisable to use cdosysmail even in SQL 2008? Or sp_send_dbmail is better?

    What do you mean by "better"?

    --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)

  • September 17, 2014 at 3:21 pm

    #1746229

    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)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply