BUG: Xp_sendmail Sends Text Data in 4 KB Chunks

ID: Q221981

The information in this article applies to:

Microsoft SQL Server versions 6.5, 7.0

BUG #: 53752 (SQLBUG_70); 18512 (SQLBUG_65)

SYMPTOMS

The xp_sendmail extended stored procedure breaks text data into 4,096 byte pieces. Even when setting @width to a value greater than 4,096, the data is still separated at 4,096 bytes. The text is separated with a carriage return and a tab.

CAUSE

This is caused intentionally within the SQL Server code, which limits the amount of text to be sent to Mail Application Programming Interface (MAPI) at 4 KB. This limitation was introduced because earlier versions of MAPI could not process strings greater than 4 KB.

WORKAROUND

To work around this problem, send the text as an attachment using the @attachments parameter documented in SQL Server Books Online.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5 and 7.0.

Additional query words: Exchange k 4k

Keywords : SSrvStProc kbbug6.50 kbbug7.00
Version : winnt:6.5,7.0
Platform : winnt
Issue type : kbbug