Database Mail Messaging Objects

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

Name	Type	Description
sysmail_allitems (Transact-SQL)	View	Lists all messages submitted to Database Mail.
sysmail_event_log (Transact-SQL)	View	Lists messages about the behavior of the Database Mail External Program.
sysmail_faileditems (Transact-SQL)	View	Information about messages that Database Mail could not sent.
sysmail_mailattachments (Transact-SQL)	View	Information about attachments to Database Mail messages.
sysmail_sentitems (Transact-SQL)	View	Information about messages that have been sent using Database Mail.
sysmail_unsentitems (Transact-SQL)	View	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.

See Also

Concepts

Database Mail Configuration Objects
Database Mail Architecture

Help and Information

Getting SQL Server 2005 Assistance