Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

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?
0
jmbaratta
Asked:
jmbaratta
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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...
0
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.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now