Skip to content

database-mail-views-transact-sql.md

Latest commit

 

History

History
49 lines (40 loc) · 2.31 KB

database-mail-views-transact-sql.md

File metadata and controls

49 lines (40 loc) · 2.31 KB
title Database Mail Views (Transact-SQL)
description Database Mail Views (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.date 03/06/2017
ms.prod sql
ms.prod_service database-engine
ms.technology 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
ms.assetid ab8728e0-803f-4b6f-b66f-9880ec37a49e

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.

:::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)