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)
 sp_send_cdosysmail body limit of varchar(8000)

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-06 : 07:46:00
Leanne writes "I have a dynamic body of my email notification using sp_send_cdosysmail. @body is declared as varchar(8000) and my data is truncated. Any suggestion for me to get around this limitation? I do not want to attach a file. The body is a formatted html table with events and events date.

Thanks."

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-09 : 05:59:49
Search for 8000 in this topic
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -