asked
what is the best way to send email?
hi, as of now we are preparing a html body and sending emails from front end as they are triggered by user action. but now we need to send email every day at a specific time basing on the Due Date for a particular ticket. so some of my friends suggested to use database mail option. will it be an efficient way or any other alternative is there..?
This site works by voting. Please indicate all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
Yes, DB mail is an inbuilt tool to send mail in sql server and it's good.
I think you need to use what is appropriate for your system. DBMail is great if you are using it in combination with the SQL engine to send database data or to send notifications in response to data conditions. If your UI is working directly with the email server and there is no need to involved SQL Server then dont. It will just bring another object in to the process that is an extra layer to debug when something breaks.
17 People are following this question.
