Disable and re-enable all indexes in a SQL Server database

Question

I am running a DTS to preform tasks in my database, in which at first I need to disable all indexes in the database and re-enable them when the DTS finish his work.

Is there a way that I can disable all the indexes in the whole database and afterwards to re-enable them all?

I know how to disable/enable one by one, can someone help me with the way to disable/enable all at once as a step in the DTS.

Answer 1

We can use below scrip to disable indexes

ALTER INDEX ALL ON [TableName] DISABLE; 

Do your bulk insert to table and than run below script.

ALTER INDEX ALL ON [TableName] REBUILD;