BUG: BOL Incorrectly States That the xp_readmail @suppress_attach Option Defaults to TRUE (303667)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q303667
BUG #: 354730 (SHILOH_BUGS)

SYMPTOMS

The "xp_readmail" T-SQL article in SQL Server Books Online (BOL) incorrectly states that the default value for the @suppress_attach parameter is TRUE:

[@suppress_attach =] 'suppress_attach'

Is whether mail attachments are suppressed. suppress_attach is varchar(255), with a default of TRUE (do not create temporary files).

In fact, the default value is FALSE, which means that if the option is not explicitly specified, temporary files are created when messages with attachments are read.

WORKAROUND

To suppress the creation of a temporary file as a copy of the attachment, explicitly use the @suppress_attach = 'TRUE' statement.

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/3/2003
Keywords:kbbug kbpending KB303667