SQL Server Performance Forum – Threads Archive
Problems with xp_sendmailGreetings, 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 0
xp_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:
MS, MCDBA, OCA, CIW