tablas importantes troubleshotting correo

tablas_email_sqlserver2008r2.sql

USE msdb
GO

sysmail_help_queue_sp @queue_type = 'Mail' ;

SELECT * FROM sysmail_allitems ORDER BY send_request_date DESC
SELECT * FROM sysmail_sentitems ORDER BY send_request_date DESC
SELECT * FROM sysmail_unsentitems
SELECT * FROM sysmail_faileditems 
SELECT * FROM sysmail_event_log ORDER BY log_date DESC
SELECT * FROM sysmail_mailitems ORDER BY send_request_date DESC
SELECT * FROM sysmail_log ORDER BY log_date DESC