• Although this is a SQL 2000 issue and you are in a 2005 forum I am going to give you a clue on how to solve it.

    Don't disable the trigger just add some "state" table and check it on the trigger code

    (if state is ON, proceed with the trigger code else return from it)

    HTH


    * Noel