Thursday, June 28, 2012

Mail Status

GET DATABASE MAIL STATUS

1)  SELECT * FROM msdb.dbo.sysmail_allitems

GET DATABASE MAIL LOG STATUS

1)  SELECT * FROM msdb.dbo.sysmail_event_log


No comments:

Post a Comment