And if I remember correctly when I had a need to disable and enable triggers in a closed process it had to be done using dynamic SQL as the disable and enable of the triggers had to the first (only?) statement(s) in the batch. Just as a note, this was also as part of an application upgrade so NO USERS where able to access the system while this process ran.