Article ID: 315666
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
This article was previously published under Q315666
BUG #: 351475 (SHILOH_BUGS)
SYMPTOMS
When you use the xp_sendmail system extended stored procedure to distribute mail to a personal distribution list, the process may fail with the following error message:
CAUSE
The xp_sendmail system extended stored procedure may not be able to resolve a personal distribution list.
WORKAROUND
To work around the problem you can use either of these methods:
- Use SQLAgentMail to distribute mail to personal distribution lists. -or-
- Itemize the individual recipients of the personal distribution list in the @recipients parameter of the xp_sendmail system extended stored procedure.
STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000.
REFERENCES
SQL Server 2000 Books Online: topics; "SQL Mail"; "Configuring Mail Profiles"; "How to set up SQLAgentMail"
Additional query words: sqlmail sql mail email DL group alias global address book
Keywords: kbbug kbpending KB315666