I want to send email from sql server using XP_SMTP_sendmail. problem is that whenever my message content exceeds 8000 character then rest of my message is truncated.i know that @message size is 8000 character.
so how can i send more than 8000 characters..
help me as soon as possible.