BUG: Xp_sendmail Sends Text Data in 4 KB Chunks (221981)


The information in this article applies to:

  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q221981
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 that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:11/14/2003
Keywords:kbBug kbpending KB221981
©2003 Microsoft Corporation. All rights reserved.