Check the Status of E-Mail Messages Sent With Database Mail

USE msdb ; GO -- Show the subject, the time that the mail item row was last -- modified, and the log information. -- Join sysmail_faileditems to sysmail_event_log -- on the mailitem_id column. -- In the WHERE clause list items where danw was in the recipi

msdn.microsoft.com