xp_sendmail from User Stored Procedure

[klewis10367]

I am using the xp_sendmail SP within another Stored Procedure and the question I have is the e-mail that is generated is coming from SQL Mail. Is there any way to have thea email come from another Account without changing the sql mail set up?

 

[MissTipps]

In short, with SQL Mail, the answer is no.

MissTipps

CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

 

[mrdenny]

The easiest solution is to Google for and download xp_smtp_sendmail. This will allow you to specify the from, email address, etc as it uses SMTP to send the emails.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[maswien]

you can try using the srored procedure : sp_sendemail.