Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Database Mail Messaging Objects

Database Mail exposes the following objects in the msdb database when Database Mail is enabled.




sysmail_allitems (Transact-SQL)


Lists all messages submitted to Database Mail.

sysmail_event_log (Transact-SQL)


Lists messages about the behavior of the Database Mail External Program.

sysmail_faileditems (Transact-SQL)


Information about messages that Database Mail could not sent.

sysmail_mailattachments (Transact-SQL)


Information about attachments to Database Mail messages.

sysmail_sentitems (Transact-SQL)


Information about messages that have been sent using Database Mail.

sysmail_unsentitems (Transact-SQL)


Information about messages that Database Mail in currently trying to send.

sp_send_dbmail (Transact-SQL)

Stored Procedure

Sends e-mail messages using Database Mail.

sysmail_delete_log_sp (Transact-SQL)

Stored Procedure

Deletes messages from the Database Mail log.

sysmail_delete_mailitems_sp (Transact-SQL)

Stored Procedure

Deletes mail items from the Database Mail queue.

sysmail_help_status_sp (Transact-SQL)

Stored Procedure

Indicates if Database Mail is started.

sysmail_start_sp (Transact-SQL)

Stored Procedure

Starts the Service Broker objects that the external program uses. These objects are started by default.

sysmail_stop_sp (Transact-SQL)

Stored Procedure

Stops the Service Broker objects that the external program uses.

These objects are the interface for Database Mail within the mail host database. Other objects are installed to implement the functionality provided by the objects listed above. However, those objects are reserved for internal use.

Use the Database Mail views to troubleshoot Database Mail. For more information, see Troubleshooting Database Mail.

The msdb database contains stored procedures for configuring Database Mail. For more information about those procedures, see Database Mail Configuration Stored Procedures.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft