Database Mail 檢視 (Transact-SQL)Database Mail Views (Transact-SQL)

本主題的適用對象: 是SQL Server沒有Azure SQL Database沒有Azure SQL 資料倉儲沒有Parallel Data WarehouseTHIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Database Mail 具有下列檢視,可顯示 Database Mail 電子郵件內容、電子郵件狀態和任何收到的訊息,如 Database Mail 記錄的錯誤。Database Mail has the following views for displaying Database Mail e-mail content, status of e-mails, and any messages received, such as errors logged by Database Mail. 這些檢視表位於msdb資料庫。These views are in the msdb database.

sysmail_allitems (Transact-SQL)sysmail_allitems (Transact-SQL) sysmail_mailattachments (Transact-SQL)sysmail_mailattachments (Transact-SQL)
sysmail_event_log (Transact-SQL)sysmail_event_log (Transact-SQL) sysmail_sentitems (Transact-SQL)sysmail_sentitems (Transact-SQL)
sysmail_faileditems (Transact-SQL)sysmail_faileditems (Transact-SQL) sysmail_unsentitems (Transact-SQL)sysmail_unsentitems (Transact-SQL)

另請參閱See Also

Database Mail Database Mail
Database Mail 組態物件 Database Mail Configuration Objects
Database Mail 預存程序(Transact SQL)Database Mail Stored Procedures (Transact-SQL)