How can I use SQL SERVER trigger to send an email in C#

I am building service failure notification system which notifies customers and management whenever there is a delay in the service. How can I use SQL SERVER trigger to send an email to a group of people when I add an alert in the alert database table using c#.

Why not just send the alert email at the same time as inserting the message in the database?

I read this awhile back, it might help you:

http://www.datasprings.com/Resources/ArticlesInformation/CreatingEmailTriggersinSQLServer2005.aspx

Good Luck

Thank you. This is what I needed.