SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by wfvdijk / disable/enable indexes for table / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 15:56:54 GMT20RE: disable/enable indexes for tablehttp://www.sqlservercentral.com/Forums/Topic552523-1009-1.aspxPerhaps a correlary script to disable contraints and triggers when copying large amounts of data from one database to another is[code]sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"gosp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"gosp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"gosp_msforeachtable "ALTER TABLE ? ENABLE TRIGGER all"go[/code]SteveThu, 16 Oct 2008 07:25:25 GMTsteve blockdisable/enable indexes for tablehttp://www.sqlservercentral.com/Forums/Topic552523-1009-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/mssql+2005/64018/">disable/enable indexes for table</A>[/B]Thu, 14 Aug 2008 03:59:22 GMTWilfred van Dijk