Microsoft KB Archive/303665

= BUG: BOL Incorrectly States That Data Type for @set_user in sp_processmail Is Sysname =

Article ID: 303665

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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

Keywords: kbbug kbpending KB303665

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.