Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XP_SENDMAIL FOR SQL2005 Expand / Collapse
Author
Message
Posted Tuesday, August 19, 2008 6:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, October 24, 2008 1:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 3, 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
Posted Tuesday, May 26, 2009 10:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, January 5, 2010 6:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 4, 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 »

Add to briefcase

Permissions Expand / Collapse