BUG: BOL Incorrectly States That Data Type for @set_user in sp_processmail Is Sysname (303665)



The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q303665
BUG #: 354774 (SHILOH_BUGS)

SYMPTOMS

The sp_processmail article in SQL Server Books Online states the following about the data type of @set_user:

[@set_user =] 'user'

Is the security context in which the query should be run. user is sysname. If user is not specified, the security context defaults to that of the user executing xp_sendmail.

However, @set_user is declared as data type VARCHAR(132), not as sysname.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000 documentation.

MORE INFORMATION

For related information on SQL Server 7.0, see the following article in the Microsoft Knowledge Base:

239074 Sp_processmail Returns Datatype Error Message


Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug kbpending KB303665