http://www.codeproject.com/Articles/25600/Triggers-Sql-Server

http://www.kodyaz.com/articles/sql-trigger-example-in-sql-server-2008.aspx