sp_send_dbmail

External Since: Jun 20, 2008 Posts: 1

Hello,
I'm developing a html mailshot using sp_send_dbmail. It is functioning
perfectly except that the html received in the email is truncated to 2000
characters. I suspect that the mail server may have a 2000 character limit
on messages. Can you advise if there may be some sql issue causing this?
Thanks SOC.

External Since: Jun 01, 2004 Posts: 652

"SOC" wrote in message

> Hello,
> I'm developing a html mailshot using sp_send_dbmail. It is functioning
> perfectly except that the html received in the email is truncated to 2000
> characters. I suspect that the mail server may have a 2000 character limit
> on messages. Can you advise if there may be some sql issue causing this?
> Thanks SOC.
>
Hi

BOL says the body can be a nvarchar(max) so there is up to 2GB. If this
always exactly 2000 characters you can ignore issues with control or
unescaped characters, but if a message is too long you tend to get an error
sent back, so it may be an account configuration issue. Have you tried
sending emails from other sources? Have you tried using your own local SMTP
relay?

John