Database Mail Views (Transact-SQL)

Applies to: SQL Server

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_event_log (Transact-SQL)

sysmail_faileditems (Transact-SQL)

sysmail_mailattachments (Transact-SQL)

sysmail_sentitems (Transact-SQL)

sysmail_unsentitems (Transact-SQL)

Database Mail
Database Mail Configuration Objects
Database Mail stored procedures (Transact-SQL)

Feedback

Var denne side nyttig?

Last updated on 2026-08-24

Database Mail Views (Transact-SQL)

Related content

Feedback

Yderligere ressourcer