August 19, 2008 at 6:02 am
Comments posted to this topic are about the item XP_SENDMAIL FOR SQL2005
October 24, 2008 at 1:22 pm
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?
May 26, 2009 at 10:51 am
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!
January 5, 2010 at 6:35 am
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