disable/enable indexes for table

Question

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

steve block SSCertifiable Points: 7698 More actions · Answer 1

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

Cookies on SQLServerCentral