Email notification service architecture.
I need to send notification email on a specific change to a field in database table. I need to also track if the email was delivered or not. If the email is not delivered, it should be logged for a different process. Can someone please help me to architect an efficient design. IS it good to go with sql 2005 notification service? or a simple windows service component? It is .NET c# application. Please give an overview of architecture and design, any help with code will also be appreciate.