Problems with xp_sendmail | SQL Server Performance Forums

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 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:;EN-US;Q315666& You may want to try: ———-
T Kelley