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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how to send mail if body of the mail is grater than 8000 cha

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-12-19 : 09:03:54
poonam writes "I am sending an auto email through sql server 2000 job.

I have written a sp to send mail.But when the length of the body becomes greater than 8000 it is not sending any mail.As the maximum limit of the varchar is 8000.Please suggest me what can I do in order to send mail with length grater than 8000.

I cannot use text datatype as send mail sp is called within another sp.Please reply me soon
Thanks a lot."
   

- Advertisement -