SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database

最新推荐文章于 2025-08-15 09:00:49 发布

转载最新推荐文章于 2025-08-15 09:00:49 发布 · 225 阅读

文章标签：

#database #sql server #email #sql #table

SQL Monthly Maintanence 专栏收录该内容

10 篇文章

订阅专栏

本文介绍如何在SQL Server 2008中使用sp_send_dbmail存储过程配置数据库邮件服务，发送测试邮件，并验证邮件发送状态及日志记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

USE msdb GO EXEC sp_send_dbmail @profile_name = 'PinalProfile' , @recipients = 'test@Example.com' , @subject = 'Test message' , @body = 'This is the body of the test message. Congrates Database Mail Received By you Successfully.'

Database Mail keeps copies of outgoing e-mail messages and displays them in the sysmail_allitems, sysmail_sentitems , sysmail_unsentitems , sysmail_faileditems . The status of the mail sent can be seen in sysmail_mailitems table, when the mail is sent successfully the sent_status field of the sysmail_mailitems table is set to 1 which can again be seen in sysmail_sentitems table. The mails that are failed will have the sent_status field value to 2 and those are unsent will have value 3.
The log can be checked in sysmail_log table as shown below:

SELECT * FROM sysmail_mailitems GO SELECT * FROM sysmail_log GO