Handling trigger is a very simple, and very misunderstood facet of SQL Server programming. Today I'll take a look some very common trigger scenarios, some mistakes made, and how you can program around them. First, a little bit of background of the types of triggers available in SQL Server. Trigger Types There are two different types of SQL Server triggers to date: INSTEAD OF triggers and AFTER triggers. INSTEAD OF triggers are placed on tables and views (most often views) and are invoked INSTEAD...