What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SQL Mail 2005 - 8000 Character Body Limitation
Posted on 2007-12-05
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
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...
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...
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted? Many believe this is the case.
Let us try to examine for ourselves with an example.
To get started, use the following script, wh…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 17 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.