Home Forums SQL Server 2005 Administering Enable/Disable all indexes in all tables at once RE: Enable/Disable all indexes in all tables at once

  • November 6, 2015 at 10:38 pm

    #1838391

    Script to disable index:

    ALTER Index indexname ON tablename.columnname DISABLE;

    Script to enable index:

    ALTER Index indexname ON tablename.columnname REBUILD;