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

Sending mail using xp_smtp_sendmail Expand / Collapse
Author
Message
Posted Friday, July 18, 2008 3:03 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 7:00 AM
Points: 278, Visits: 78
Hi All,

I am using xp_smtp_sendmail to send email from DTS SQL SERVER 2000.

If i gave a invalid recipient it should bounce back a email to the sender. Is it possible?

While executing the stored procedure it the giving
Error: Sending Message
Server Response: 550 Mailbox unavailable.

But the stored procedure return 1 when there is an error. How to capture the above error and based on this i have to send an notification email for the invalid recipient.

Pls help me.

Regards,
Bhuvana
Post #536559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse