SQL Server Performance

Problems with xp_sendmail

Discussion in 'General DBA Questions' started by jfogel, Jan 27, 2003.

  1. jfogel New Member

    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 = 'jfogel_34683@yahoo.com',@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", "jfogel@atsrmis.com" and my yahoo account. I upgraded to sp3 in hopes that the problem was there. Any thoughts?
  2. tkelley New Member

Share This Page