This topic describes how to check the status of the e-mail message sent using Database Mail in SQL Server 2014 by using Transact-SQL.
msdn.microsoft.com