XP_SENDMAIL FOR SQL2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rob Hendershot » XP_SENDMAIL FOR SQL2005

XP_SENDMAIL FOR SQL2005

Rate Topic

Display Mode

Topic Options

Author

Message

Robo-704698

Posted Tuesday, August 19, 2008 6:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 27, 2009 11:17 AM
Points: 2, Visits: 12

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

Post #554920

xliu75

Posted Friday, October 24, 2008 1:22 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 9:25 AM
Points: 1, Visits: 44

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?

Post #591466

Martin S. Stoller

Posted Tuesday, May 26, 2009 10:51 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, April 10, 2012 10:00 AM
Points: 23, Visits: 22

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!

Post #723429

jiten.maken

Posted Tuesday, January 05, 2010 6:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 04, 2010 1:52 AM
Points: 1, Visits: 2

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

Post #842027

« Prev Topic | Next Topic »

Permissions