XP_SENDMAIL FOR SQL2005

  • Comments posted to this topic are about the item XP_SENDMAIL FOR SQL2005

  • We was using

    exec xp_sendmail @recipients='[fax:1xxxyyyzzzz]',

    @message='new xp_sendmail',

    @copy_recipients='xxx@xxx.com',

    @subject='test'

    to send fax (of course this is fax server after exchange server)

    sql server-->exchange server---> fax server

    after we change to use exec sp_send_dbmail @recipients='[fax:1xxxyyyzzzz]',

    @body='new xp_sendmail',

    @copy_recipients='xxx@xxx.com',

    @subject='test'

    it is not work. (not recognized email address)

    Any idea?

  • Great idea, and one can set a default DB MAIL profile in the parameter list (is what I did), so it will work by default (I think this might be the issue the previous commenter had - they forgot to set @profile_name - which of course msdb.dbo.sp_send_dbmail needs...)

    Cheers!

  • All i have to say is that you are a frikking GODSEND lol

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply