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..?
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.