Status: Solved
Priority: Medium
Security: Public
Views: 407
Last Modified: 2012-06-27

SQL Mail 2005 - 8000 Character Body Limitation

We are trying to use SQL Mail to automatically generate emails. The components is working, however, we are running into an issue concerning the body limit of 8000 characters. Is there a way to increase this limit, or is there a workaround that might be helpful?

jmbaratta

Asked: 2007-12-05

Advertise Here

Microsoft SQL Server 2005

1 Solution

LVL 143

Guy Hengel [angelIII / a3]Billing EngineerCommented: 2007-12-05

are you using SQL Mail (ie xp_sendmail)? then, you are limited to 8000:
http://msdn2.microsoft.com/en-us/library/ms189505.aspx

if you want more than that, you have to use some other (third-party) tools to send the mail via SMTP...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

SQL Mail 2005 - 8000 Character Body Limitation

Join & Write a Comment Already a member? Login.

Featured Post