FIX: xp_readmail Leaks Memory if Message Contains Attachment

Article translations Article translations
Article ID: 290814 - View products that this article applies to.
This article was previously published under Q290814
BUG #: 352312 (SHILOH_bugs)
Expand all | Collapse all


Calling the xp_readmail extended procedure to read a message that contains one or more attachments leaks memory. The memory leak is associated with some data structures allocated to hold information about the attachment, such as its size and the filename.


To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack


Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.


You can see the memory leak by using the System Monitor or Performance Monitor and viewing the "Private Bytes" counter for the sqlservr process. The rate at which SQL Server memory usage increases depends on the number of attachments per message and the length of the attachment names. Attachments with long file names result in more memory being allocated and a faster leak.


Article ID: 290814 - Last Review: November 6, 2003 - Revision: 3.2
  • Microsoft SQL Server 2000 Standard Edition
kbbug kbfix kbsqlserv2000sp1fix KB290814

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from