I need to disable all triggers temporarily on a SQL Server DB (2008) so I can run some insert scripts against it. How can I do this with one statement? I don't really feel like going through each individual trigger on 65 tables and disabling them. Also, I need to know how to re-enable them when the scripts are done. Thanks.