view information about mail in msdb database using the following scripts:

view information about mail in msdb database using the following scripts:

 
use msdb
go
 
 
SELECT * FROM sysmail_server
SELECT * FROM sysmail_allitems 
SELECT * FROM sysmail_sentitems
SELECT * FROM sysmail_unsentitems 
SELECT * FROM sysmail_faileditems 
SELECT * FROM sysmail_mailitems
SELECT * FROM sysmail_log

Leave a Reply

Your email address will not be published. Required fields are marked *