Skip to content

Latest commit

 

History

History
48 lines (38 loc) · 2.17 KB

database-mail-views-transact-sql.md

File metadata and controls

48 lines (38 loc) · 2.17 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords dev_langs
Database Mail Views (Transact-SQL)
Database Mail Views (Transact-SQL)
rwestMSFT
randolphwest
03/06/2017
sql
system-objects
reference
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
TSQL

Database Mail Views (Transact-SQL)

[!INCLUDEsqlserver]

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.

:::row::: :::column::: sysmail_allitems (Transact-SQL)

    [sysmail_event_log (Transact-SQL)](../../relational-databases/system-catalog-views/sysmail-event-log-transact-sql.md)
    
    [sysmail_faileditems (Transact-SQL)](../../relational-databases/system-catalog-views/sysmail-faileditems-transact-sql.md)
:::column-end:::
:::column:::
    [sysmail_mailattachments (Transact-SQL)](../../relational-databases/system-catalog-views/sysmail-mailattachments-transact-sql.md)
    
    [sysmail_sentitems (Transact-SQL)](../../relational-databases/system-catalog-views/sysmail-sentitems-transact-sql.md)
    
    [sysmail_unsentitems (Transact-SQL)](../../relational-databases/system-catalog-views/sysmail-unsentitems-transact-sql.md)
:::column-end:::

:::row-end:::

See Also

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