Hi there,

Another way that I use which I think will do the same thing is:

--Disable all triggers

sp_msforeachtable "ALTER TABLE ? Disable TRIGGER all"

Then when your ready to enable them again:

--Enable all triggers

sp_msforeachtable "ALTER TABLE ? Enable TRIGGER all"

I've used this plenty of times in SQL2005 and although I haven't tried in 2008 as yet, I expect it will work.