Skip to content

database-mail-views-transact-sql.md

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
title Database Mail Views (Transact-SQL)
description Database Mail Views (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.date 03/06/2017
ms.service sql
ms.subservice system-objects
ms.topic reference
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
dev_langs
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)