Our e-commerce site requires the sending of email Currently, for some odd reason, the server that is being used to do this is the database server... which clearly isn't ideal (i've just taken over here)
My idea is this - to write a windows service that checks for new mails that need sending (these are all in a sql db) and then process the mails seperately... I want to use a seperate mail server, to keep this efficient..
Has anyone had any experience of this?
Would it be sensible to (for example) set up a lightweight debian (or other distro) machine, with exim on? Would i be able to use that as the host ip address when specifying my smtp server to send email? I'm going to be using C#....