RebuildIndex1.sql

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

SET @fillfactor = 95

set @cmd = 'DECLARE TableCursor CURSOR FOR SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' + 
  table_name + '']'' as tableName FROM INFORMATION_SCHEMA.TABLES 
  WHERE table_type = ''BASE TABLE'''   

-- create table cursor  
EXEC (@cmd)  
OPEN TableCursor   

FETCH NEXT FROM TableCursor INTO @Table   
WHILE @@FETCH_STATUS = 0   
BEGIN   
   SET @cmd = 'ALTER INDEX ALL ON ' + @Table + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')' 
   EXEC (@cmd) 

   FETCH NEXT FROM TableCursor INTO @Table   
END   

CLOSE TableCursor   
DEALLOCATE TableCursor