Link to home
Create AccountLog in
Avatar of Data-Man
Data-ManFlag for United States of America

asked on

How big can the body parameter of sp_send_dbmail be?

Hello all,
   I have a pretty simple question.  I should probably know this because the words are right in front of me, but I want to make sure that I'm looking at it correctly.

   In the help file for sp_send_dbmail it states that the Body can be NVARCHAR(MAX).  What does that mean?  Does that mean only 4K?

Thanks,
Mike
Avatar of chapmandew
chapmandew
Flag of United States of America image

2BG is the max for varchar(max)
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Data-Man

ASKER

Thanks....that helps.
I was thinking that it was 4K because of the declare statement.  We just moved from SS 2000 to SS 2005 last week.


Regards,
Mike