Triggers do still have one legitimate use that constraints cannot handle. If the logical design includes super and sub-types, and the physical implementation is the one table per child choice...
Quest Software offers a new tool - TOAD for SQL Server - which is still in its infacny but will some day soon offer exactly what you're looking for -...