Microsoft KB Archive/221981

= BUG: Xp_sendmail Sends Text Data in 4 KB Chunks =

Article ID: 221981

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: Exchange k 4k

Keywords: kbbug kbpending KB221981

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.