SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON

DECLARE @Table VARCHAR(255)
DECLARE @cmd NVARCHAR(500)
DECLARE @fillfactor INT

SET @fillfactor = 90



DECLARE TableCursor CURSOR FOR SELECT '['+[TABLE_CATALOG] + '].' + '['+[TABLE_SCHEMA] + '].' + '['+[TABLE_NAME] + ']' as tableName FROM INFORMATION_SCHEMA.TABLES
WHERE [TABLE_TYPE] = 'BASE TABLE'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @Table
WHILE @@FETCH_STATUS = 0
	BEGIN

	IF (@@MICROSOFTVERSION / POWER(2, 24) >= 9)
	BEGIN
		SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD WITH    (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'
		EXEC (@cmd)
	END
	ELSE
	BEGIN
		DBCC DBREINDEX(@Table,' ',@fillfactor)
	END

	FETCH NEXT FROM TableCursor INTO @Table
END
CLOSE TableCursor
DEALLOCATE TableCursor