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

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Just Learned

A collection of quick technology learning tips from what people around you learn every day


	Submit a tip


	Subscribe..

Home · Most Liked · Most Learned · Most Discussed · Silver Rated · Sections

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]

Published under: SQL Server Tips · · · ·

Previous: General - Let it snow competition in Google & Microsoft
Next: Silverlight - Necessity of Cross domain Policy files to access services

Fazal Vahora

21 · 9% · 2806

Liked

Knew

Learned

Incorrect

Interesting

Forgotten


Post this to my facebook wall
Tweet this
Like This
I knew this before
Thanks, I just learned it from you
Sorry, but this is not correct
Interesting, but not my area
I knew it but i have forgotten it


	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

Your Comment