title: build email notification sytem that send emails on sql server triggers
body: <p>I have a web project which is written in C# and uses 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 haven't done this system before and I want to know how other people do it.</p>
  
  <p>What I have in my mind is to create a <code>Queue</code> table and and triggers for the tables I want to watch for changes. When the trigger is executed, it will insert an email request to the <code>Queue</code> table. Later, I will loop that queue table and send emails. I might be using Amazon web services to send emails in near future but not decided yet.</p>
  
  <p>Do you think this is a good idea?</p>