This portal is to share my acquired knowledge related to Sql Server. I hope will be helpful for novice and professionals.

Monday, September 19, 2011

Database mail log using TSQL (Just Learned)

SYSMAIL_ALLITEMS is a view in MSDB database is used to check database mail log .
Contains one row for each message processed by Database Mail. This is really helpfull view to troubleshoot notifications .

No comments: