Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2011-11-12 : 09:47:26
|
| Hi,We are using SP to send email through sql server. But when the length of the message exceeds more than 8000 characters, that entire message is not generating when the email sends out.Is there any other way we can send out the email when message exceeds more than 8000 characters. Please help. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-12 : 10:05:34
|
| Depends how you are sending the email. It should take a varchar(max) for the body.If it is the sp inteface then try retrievig the text from a table in the sp if you can't transfer more than 8000 chars.Could also try sending it as an attachment.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-12 : 11:55:11
|
quote:
Originally posted by velliraj
Hi,We are using SP to send email through sql server. But when the length of the message exceeds more than 8000 characters, that entire message is not generating when the email sends out.Is there any other way we can send out the email when message exceeds more than 8000 characters. Please help.
why not write message onto file and add file as an attachment to email?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
8000characters