Post reply

Is there a replacement for CDONTs I can use in SQL 2008

  • February 9, 2011 at 11:04 am

    #244921

    On an old server running SQL 2000 I had a procedure that sent email by calling sp_OACreate something like this ...

    EXEC @resultcode = sp_OACreate 'CDONTS.NewMail', @oMail OUT (something like that) (which used the CDONTs mail object to send email to a SMTP mailserver.

    Is there a more recent version of CDONTS available on later servers like Windows 2008 that I can use in SQL Server 2008? I can't seem to get anywhere with DatabaseMail

    Thanks for any help

  • February 9, 2011 at 11:14 am

    #1284697

    CDONTS and SQLMail are deprecated. DatabaseMail is the way to go. It's much easier because you just need a SMTP server to bounce your mail through instead of having to have the MAPI client installed on your SQL Server the way you did with SQLMail.

    The stored procedure to send mail through DatabaseMail is sp_send_dbmail.

    Check out: http://msdn.microsoft.com/en-us/library/ms175887.aspx

  • February 9, 2011 at 4:31 pm

    #1284894

    Thank you.

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

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