SQL Toolkit

DECLARE @sql NVARCHAR(MAX)

DECLARE db_cursor CURSOR FOR
SELECT 'ALTER INDEX [' + sys.indexes.name + '] ON [' + sys.objects.name + '] REBUILD '
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

OPEN db_cursor
FETCH NEXT FROM db_cursor1 INTO @sql

WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT @sql
    EXEC sp_executesql @sql

    FETCH NEXT FROM db_cursor INTO @sql
END

CLOSE db_cursor

DEALLOCATE db_cursor