Today I had a requirement of finding the details of mails that sent using Database Mail feature. "sysmail_allitems" catalog view will contains the details like subject,body,recipients,CC,BCC,status,send date,file attachment etc. check out following query.

I just learned today new thing,"How to delete old e-mail messages from database mail internal tables with using sysmail_delete_mailitems_sp" check out following query. [code] USE MSDB GO Exec sysmail_delete_mailitems_sp @sent_before ='2011/12/14',@sent