BUG: Xp_sendmail Fails If @recipients Parameter Is More Than 256 Characters (324191)
The information in this article applies to:
This article was previously published under Q324191
BUG #: 55060 (SQLBUGS_70)
SYMPTOMS
You may receive the following error message if the @recipients parameter of the xp_sendmail stored procedure is greater than 256 characters:
Msg 17914, Level 18, State 1, Line 0
Unknown recipient: Parameter '@recipients', recipient 'someone@example.c'
In the error message example, the e-mail address someone@example.com is truncated to someone@example.c if the @recipients parameter is more than 256 characters. NOTE: The same error message can occur for conditions other than this bug. Make sure to verify that your situation matches the symptom in this article.
CAUSE
Because of a limitation for the length of the @recipients parameter, the string you provide to @recipients is truncated to 256 characters. The e-mail address that crosses the 256 character boundary is therefore incomplete and you receive the 17914 error message.
WORKAROUND
To work around this behavior, reduce the length of the @recipients parameter to less than 256 characters.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 7/25/2002 |
|---|
| Keywords: | kbbug KB324191 |
|---|
|