Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/315666

From BetaArchive Wiki
Knowledge Base

Article ID: 315666

Article Last Modified on 10/3/2003


  • Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q315666

BUG #: 351475 (SHILOH_BUGS)


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:

Server: Msg 18031, Level 16, State 1, Line 0
xp_sendmail: could not resolve recipient


The xp_sendmail system extended stored procedure may not be able to resolve a personal distribution list.


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.


Microsoft has confirmed that this is a problem in SQL Server 2000.


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