Contains one row for each attachment submitted to Database Mail. Use this view when you want information about Database Mail attachments. To review all e-mails processed by Database Mail use sysmail_allitems (Transact-SQL).
Identifier of the attachment.
Identifier of the mail item that contained the attachment.
The file name of the attachment. When attach_query_result is 1 and query_attachment_filename is NULL, Database Mail creates an arbitrary filename.
The size of the attachment in bytes.
The content of the attachment.
The date and time of the last modification of the row.
The user who last modified the row.
When troubleshooting Database Mail, use this view to see the properties of the attachments.
Attachments stored in the system tables can cause the msdb database to grow. Use sysmail_delete_mailitems_sp to delete mail items and their associated attachments. For more information, see How to: Create a SQL Server Agent Job to Archive Database Mail Messages and Event Logs.