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
johnwalker10
SSCrazy Eights
Points: 9124
More actions
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;