build email notificaiton sytem that send emails on sql server triggers

[IDaundrea]

I have a web project which is written on c# and sql server. I need to write an email notification system. I did some research and some people suggest to use CLR and some suggest to the business logic in c# code. I havent done this system before and I want to know how other people do it.What I have in my mind is to create Queue table and and triggers for the tables I want to watch for changes. When the trigger is executed, the trigger will insert a email request to the queue table. Later, I will loop that queue table and send emails. I might be using Amazon Webservices to send emails in near future but not decided yetdo you think this is a good idea?