InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 20:59:55 GMT20http://www.sqlservercentral.com/Forums/Topic401734-533-1.aspxThis is the same script without the overhead of the cursor and taking into account that views are also in the information_schema.tables view (and should not be returned byt the query:DECLARE @TableName varchar(255)SET @TableName = (SELECT TOP 1 TABLE_NAME FROM information_schema.tables WHERE table_name not like 'sys%' and table_name &lt;&gt;'dtproperties' and TABLE_TYPE = 'BASE TABLE' order by TABLE_NAME asc)WHILE @TableName is not nullBEGIN PRINT 'Reindexing ' + @TableName BEGIN TRY DBCC DBREINDEX(@TableName,' ',0)-- change fill factor here as per your requirement END TRY BEGIN CATCH PRINT 'Error reindexing ' + @TableName END CATCH SET @TableName = (SELECT TOP 1 TABLE_NAME FROM information_schema.tables WHERE table_name not like 'sys%' and table_name &lt;&gt;'dtproperties' and TABLE_TYPE = 'BASE TABLE' and cast(table_name as varchar(255)) &gt; @TableName order by TABLE_NAME asc)ENDWed, 02 Apr 2008 10:39:20 GMTjmartin-697613http://www.sqlservercentral.com/Forums/Topic401734-533-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Index+Management/31641/">Simple script to ReIndex complete database</A>[/B]Sun, 23 Sep 2007 16:48:12 GMTSanjayAttray