You are currently offline, waiting for your internet to reconnect
Questions about Windows 10? Click here

BUG: xp_sendmail with @query leaves temporary files on server

This article has been archived. It is offered "as is" and will no longer be updated.
BUG#: 15268BUG#: 226802 (Shiloh_bug)
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.
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.
Status
Microsoft has confirmed this to be a problem in Microsoft SQL Serverversions 6.0 and 6.5.
xp_startmail @query
Properties

Article ID: 151545 - Last Review: 01/16/2015 18:22:17 - Revision: 5.0

  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • kbnosurvey kbarchive kbbug KB151545
Feedback