HELP - sp_send_dbmail @body - character limit?!?

[katbear]

Hi,

According to the BOL documentation, the datatype for the @body parameter for the sp_send_dbmail procedure is a NVARCHAR(MAX).

So, why is it, when I try to send mail with a @body > 8000 characters, it chops off everything after the 8000 mark???

Is there a setting I need to set?

Help. This is serious problem.

Thanks

 

[katbear]

never mind...

i see that all the input params and @body variables need to be NVARCHAR(MAX)