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..