disable/enable indexes for table

• Wilfred van Dijk

  SSCrazy Eights

  Points: 9003

  More actions

  August 14, 2008 at 3:59 am

  #211240

  Comments posted to this topic are about the item disable/enable indexes for table

  Wilfred
  The best things in life are the simple things

• steve block

  SSCertifiable

  Points: 7698

  More actions

  October 16, 2008 at 7:25 am

  #885805

  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