SQL Server Performance Forum – Threads Archive
Problems with xp_sendmail
Greetings, I am having a problem with xp_sendmail on a SQL Server 2k only. This works in 7 but not 2K. exec master.dbo.xp_sendmail @recipients = ‘[email protected]‘,@message = ‘I have completed’ I get: Server: Msg 18031, Level 16, State 1, Line 0xp_sendmail: Could not resolve recipient My mail runs fine for the jobs I use with the SQL Agent. It’s only when I try it from ISQLW. I’ve tried my exchange name "jfogel", "[email protected]" and my yahoo account. I upgraded to sp3 in hopes that the problem was there. Any thoughts?
This is what Microsoft has to say about SQL 2000’s xp_sendmail:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q315666& You may want to try:
http://www.sqldev.net/xp/xpsmtp.htm ———-
T Kelley
MS, MCDBA, OCA, CIW
]]>