How to Enable or Disable Index on Table using SQL

Index Status: 

select 

    sys.objects.name, 

    sys.indexes.name 

from sys.indexes 

    inner join sys.objects on sys.objects.object_id = sys.indexes.object_id 

where sys.indexes.is_disabled = 1 

order by 

    sys.objects.name, 

    Sys.indexes.name 

----------------------------------------------------------------------------------- 

Index Disable: 

use DB 

go 

ALTER INDEX Index_name ON Table_name 

DISABLE; 

-------------------------------------------------------------------------------- 

Index Enable: 

use ACTIVEQUOTE 

go 

ALTER INDEX Index_name ON Table_name 

rebuild