BUG: Memory Leak with Xp_sendmail Using Attachments

ID: Q245803

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 57124 (SQLBUG_70)

SYMPTOMS

Using xp_sendmail with @query and @attach_results parameters will cause a memory leak in SQL Server 7.0. 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 this to be a problem in SQL Server version 7.0.

Additional query words: memory leak xp_sendmail

Keywords : kbbug6.50 kbSQLServ700bug kbDSupport
Version : winnt:7.0
Platform : winnt
Issue type : kbbug