Microsoft KB Archive/324191

= BUG: Xp_sendmail Fails If @recipients Parameter Is More Than 256 Characters =

Article ID: 324191

Article Last Modified on 7/25/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: xp_sendmail 17914 SQL Mail

Keywords: kbbug kbpending KB324191

-

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

© Microsoft Corporation. All rights reserved.