mail server failure when i execute a stored procedure

Question

0.00/5 (No votes)

See more:

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

Posted 14-May-13 22:07pm

kalisiddayya

Add a Solution

Comments

[no name] 15-May-13 3:28am

Please share your procedure..it's difficult to understand link this...

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2013-05-14T22:34:00

Solution 1

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.

Posted 14-May-13 22:34pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

kalisiddayya 15-May-13 6:31am

I send more email around 350 email per day through sql server that create a problem .i create another profile i can send email through different profile it is going.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 15-May-13 6:34am

Still you are getting that exception ?

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 22-May-13 9:40am

Thanks for accepting the answer. :)

mail server failure when i execute a stored procedure

1 solution

Solution 1

Add your solution here

Preview 0

mail server failure when i execute a stored procedure

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us