USE MyDB;
DECLARE @FillFactor INT
SET @FillFactor=100
DECLARE @SQL NVARCHAR(500)
SET @SQL=N'ALTER INDEX ALL ON ? REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@FillFactor) + ',STATISTICS_NORECOMPUTE = ON)'
EXEC SP_MSForEachTable @SQL
USE MyDB;
DECLARE @FillFactor INT
SET @FillFactor=100
DECLARE @SQL NVARCHAR(500)
SET @SQL=N'ALTER INDEX ALL ON ? REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@FillFactor) + ',STATISTICS_NORECOMPUTE = ON)'
EXEC SP_MSForEachTable @SQL