据我所知，SQL Express 不支持数据库邮件功能，因此这是不可能的。根据 Sql 的 Database Mail MSDN 文章底部的注释服务器2008 R2：
数据库邮件在 SQL 中不可用 服务器快递。
更强大的解决方案是将通知逻辑嵌入到与数据库对话的应用程序层（例如C#）中。
As far as I know, SQL Express does not support the Database Mail feature, so this would not be possible out of the box. As per the note at the bottom of the Database Mail MSDN article for Sql Server 2008 R2:
Database Mail is not available in SQL Server Express.
A more robust solution would be to embed the notification logic in the application tier (e.g C#) which talks to the database.
发布评论
评论（3）
据我所知，SQL Express 不支持数据库邮件功能，因此这是不可能的。根据 Sql 的 Database Mail MSDN 文章底部的注释服务器2008 R2：
更强大的解决方案是将通知逻辑嵌入到与数据库对话的应用程序层（例如C#）中。
As far as I know, SQL Express does not support the Database Mail feature, so this would not be possible out of the box. As per the note at the bottom of the Database Mail MSDN article for Sql Server 2008 R2:
A more robust solution would be to embed the notification logic in the application tier (e.g C#) which talks to the database.
据我没有发现任何反对在 SQL Server Express 上启用 SQL CLR 的反对意见，
您可以尝试将 SQL CLR 触发器与
System.Net.Mail对象结合使用。As far as I didn't find any deprecation against enabling SQL CLR onto SQL Server Express,
you can try to use SQL CLR Trigger with
System.Net.Mailobjects.这是 SQL Express 不可能实现的。如果您碰巧更新到完整的 Management Studio，您将使用 msdb.dbo.sp_send_dbmail 发送电子邮件。
This is not possible with SQL Express. If you happen to update to the full management studio you would use msdb.dbo.sp_send_dbmail to send your email.