I'm using SQL Server's
sp_send_dbmail
to distribute mail. Everything is working fine; BUT I tried to test a bad email address
and it always reports success; and nothing is in the failed sent items table.
Will this procedure report IF the email isn't sent? Or is success
just getting the mail to the exchange server?
Thanks in advance!
sysmail_allitems
table (msdn.microsoft.com/en-us/library/ms175056.aspx). What is thesent_status
for that test email to the bad email address?