Perhaps a correlary script to disable contraints and triggers when copying large amounts of data from one database to another is

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

go

sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER TABLE ? ENABLE TRIGGER all"

go

Steve