0 out of 1 rated this helpful - Rate this topic

Database Mail Views (Transact-SQL)

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005
SQL Server 2012

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)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Database Mail Views (Transact-SQL)

Tasks

Reference

Concepts

Community Additions