Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Database Mail Views (Transact-SQL)
Collapse the table of content
Expand the table of content

Database Mail Views (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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)

Community Additions

ADD
Show:
© 2015 Microsoft