BUG: Memory Leak with Xp_sendmail Using Attachments (245803)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q245803
BUG #: 57124 (SQLBUG_70)

SYMPTOMS

Using xp_sendmail with @query and @attach_results parameters will cause a memory leak in SQL Server 7.0 or later. The @attach_results parameter is responsible for the memory leak, but both parameters must be used for the memory leak scenario to arise.

WORKAROUND

Do not use @attach_results with xp_sendmail.

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:10/15/2002
Keywords:kbBug KB245803
©2002 Microsoft Corporation. All rights reserved.