database-mail-views-transact-sql.md

title	Database Mail Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	monitoring Database Mail Database Mail [SQL Server], status information Database Mail [SQL Server], troubleshooting Database Mail [SQL Server], views troubleshooting [SQL Server], Database Mail status information [SQL Server], Database Mail
ms.assetid	ab8728e0-803f-4b6f-b66f-9880ec37a49e
author	stevestein
ms.author	sstein

Database Mail Views (Transact-SQL)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Database Mail has the following views for displaying Database Mail e-mail content, status of e-mails, and any messages received, such as errors logged by Database Mail. These views are in the msdb database.

sysmail_allitems (Transact-SQL)	sysmail_mailattachments (Transact-SQL)
sysmail_event_log (Transact-SQL)	sysmail_sentitems (Transact-SQL)
sysmail_faileditems (Transact-SQL)	sysmail_unsentitems (Transact-SQL)

See Also

Database Mail
Database Mail Configuration Objects
Database Mail Stored Procedures (Transact-SQL)