Click here to Skip to main content
15,885,278 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Is there any way to get SMTP status code for a mail send from SQL Server with msdb.dbo.sp_send_dbmail ?

I found SQL Server generate report of sent, unsent, retrying, and failed based on within its premises .I mean to say

If when I send mail with sp_send_dbmailand put wrong recipients E-mail address then also its show mail sent ,but actually mail not delivered, and SMTP mail log will show

550-5.1.1 The email account that you tried to reach does not exist. Please try

which is actual ,Is there any way ,that I can get SMTP status for each mail sent from SQl Server..
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900