我执行存储过程时邮件服务器失败 [英] mail server failure when i execute a stored procedure

问题描述

我创建了一个发送邮件的配置文件。我正在执行不同的程序，电子邮件正在发送到他们的帐户但在一个商店程序执行中它没有发送电子邮件我看到数据电子邮件日志文件中的错误它显示''邮件无法发送到邮件服务器''。执行程序时没有给出任何错误，只有电子邮件没有发送给其他存储过程它正在发送电子邮件罚款。请告诉我这是什么原因

i create a profile for sending mail.i am executing different procedure, emails are sending to their accounts but in one store procedure execution it is not sending the email i saw an error in the data email log file it show that ''mail cannot send to mail server''.while execution of procedure it is not give any error,only the email is not sending for other stored procedure it is sending Email fine .Please tell me what is reason for that

推荐答案

请参阅文章 - SQL SERVER - 2008 - 配置数据库邮件 - 从SQL数据库发送电子邮件 [ ^ ]并检查是否遵循了所有步骤是否正确。



请加上s有关您遵循的配置以及您所做的更改以获得此错误的更多信息。您还可以发布一些代码片段来详细说明。

Please refer the article - SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database[^] and check whether you followed all the steps correctly or not.

And please add some more info regarding what are the configurations you followed and what changes you have made so that you got this error. You can also post some code snippets to elaborate.

这篇关于我执行存储过程时邮件服务器失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！