Post reply

sp_send_dbmail and base64 encoding

  • October 19, 2008 at 6:04 pm

    #214260

    Does anyone know how to turn off the base64 encoding that sp_send_dbmail is adding to emails? I'm not sure if its normal practice to do this... I'm calling it as follows.

    exec msdb.dbo.sp_send_dbmail

    @profile_name = 'DatabaseMail',

    @recipients = @EmailAddress,

    @subject = @EmailSubject,

    @body = @EmailBody,

    @body_format = 'TEXT'

    I get this line in the email header: Content-Transfer-Encoding: base64

    The recipient isn't decoding it and its causing me some problems.

    Thanks in advance.

  • October 23, 2008 at 6:27 pm

    #888972

    I dont know the answer but would try looking into the mail profile or try different @body_format while sending mail.

  • October 23, 2008 at 6:33 pm

    #888974

    Actually I found the answer in another post at another site somewhere. I'm led to believe that Microsoft have hardcoded the base64 encoding into sp_send_dbmail.

    The problem I had was with an external company I was using to forward the mail as an SMS. They didn't have the technology to decode this.

    I ended up using a different Email->SMS company, one that could decode the base64 encoding. The problem went away as soon as I did that 😉

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

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