Getting Started with Web applications development with servlets and JSP - Part 5: Filters
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


Upload Image Close it
Select File

Learned something today? Share it, or learn from what others have learned today

SQL Server Tips

SQL Server- "sysmail_allitems" catalog view can be used to find the details of all Mails that are sent using Database Mail featu

Dec 21 2011 10:44AM by Fazal Vahora   

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.

USE MSDB
GO
SELECT [subject],body,
         recipients,copy_recipients,
         blind_copy_recipients,sent_status,
         sent_date,file_attachments 
FROM sysmail_allitems
GO
Read More..  [0 clicks]

Fazal Vahora
21 · 9% · 2012
4
 
1
 
4
 
0
Incorrect
 
0
Interesting
 
0
Forgotten
 
0
Move


Submit

Your Comment
Sign Up or Login to post a comment.
"SQL Server- "sysmail_allitems" catalog view can be used to find the details of all Mails that are sent using Database Mail featu" rated 5 out of 5 by 4 readers
SQL Server- "sysmail_allitems" catalog view can be used to find the details of all Mails that are sent using Database Mail featu , 5.0 out of 5 based on 4 ratings
    Copyright © Beyondrelational.com Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising