SQL DB mail log

Have you ever wonder what happen to your DB mail.

You can find out from MSDB. This is how:


USE MSDB
SELECT * FROM SYSMAIL_MAILITEMS
GO
SELECT * FROM SYSMAIL_LOG
GO
SELECT * FROM SYSMAIL_SENTITEMS
GO
SELECT * FROM SYSMAIL_UNSENTITEMS
GO
SELECT * FROM SYSMAIL_FAILEDITEMS
GO
SELECT * FROM SYSMAIL_MAILITEMS