And as an aside I'd strongly advise against using triggers in almost all cases. They tend to result in systems where things happen by "magic" rather than in well understood ways. If you're tempted to write a trigger, use a stored procedure instead and invoke it explicitly.