BUG: xp_sendmail with @query leaves temporary files on server

Article ID: 151545 - View products that this article applies to.
This article was previously published under Q151545
BUG#: 15268 BUG#: 226802 (Shiloh_bug)
Expand all | Collapse all

SYMPTOMS

If xp_sendmail is run with a query and @attach_results is true, temporary files are left in the System32 directory where Microsoft Windows NT is installed.
Back to the top | Give Feedback

WORKAROUND

  1. Use the optional parameter @attachments to specify the file name and only one file will be left in the System32 directory.
  2. Use the optional parameter @attachments to specify the file path to a temporary directory for easy cleanup later.
Back to the top | Give Feedback

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5.
Back to the top | Give Feedback

Properties

Article ID: 151545 - Last Review: June 7, 2005 - Revision: 4.1
APPLIES TO
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbbug KB151545
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top