Skip to content

database-mail-views-transact-sql.md

Latest commit

 

History

History
51 lines (42 loc) · 2.37 KB

database-mail-views-transact-sql.md

File metadata and controls

51 lines (42 loc) · 2.37 KB
description Database Mail Views (Transact-SQL)
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 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 WilliamDAssafMSFT
ms.author wiassaf

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)