x

Force database mail in SQL Server 2005 to change encoding base64?

Hi,

I'm trying to use Database Mail to send e-mail to a foreign address. It delivers the message but the content is encoded in base64 so it can't be read clearly by the destination.

It is a part of the message headers:

To: valle@cimex.com.cu Date: 31 Jan 2010 12:39:53 -0500 Subject: Database Mail Test Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Return-Path:

How do I force database mail in SQL Server 2005 to send e-mail in plain text instead of encoding it in base64?

more ▼

asked Jan 31 '10 at 02:57 PM in Default

JD gravatar image

JD
104 6 7 8

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Sorry friends, someone who has this very same problem told me that base64 encoding is hardcoded in the procedure, so it can't be modified...

more ▼

answered Feb 05 '10 at 12:44 AM

JD gravatar image

JD
104 6 7 8

(comments are locked)
10|1200 characters needed characters left

you could try decoding it using a SP and then using dbmail to return the result of that to the email as the body or attachment

http://www.sqlservercentral.com/scripts/Miscellaneous/31520/

more ▼

answered Jan 31 '10 at 04:36 PM

sp_lock gravatar image

sp_lock
9k 24 27 30

Thanks, but what is encoded is the email itself so, I can't decode it..!
Feb 01 '10 at 08:36 PM JD
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x29
x15

asked: Jan 31 '10 at 02:57 PM

Seen: 2651 times

Last Updated: Feb 01 '10 at 09:17 PM