• If you have multiple update triggers, be sure they don't overlap (functionally).

    IOW, if you have two and they both update own table, one will fire the other one. In such case merge them into one or at least the update part.

    You didn't mention what goes wrong nor what the triggers do.

    From Jeff's signature:

    For better, quicker answers, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/