InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 23:54:37 GMT20http://www.sqlservercentral.com/Forums/Topic401633-217-1.aspxGood work Grant. You could probably tune a little bit more for example specifying the page_count limit in the clause and modify the line fromSELECT @command = ''ALTER INDEX '' + @indexname + '' ON ?.'' + @schemaname + ''.'' + @objectname + '' REORGANIZE'';toSELECT @command = ''ALTER INDEX ['' + @indexname + ''] ON ?.['' + @schemaname + ''].['' + @objectname + ''] REORGANIZE'';Same for rebuild..Thanks again - will probably use this at some pointWed, 02 Mar 2011 03:00:22 GMTMr. Holiohttp://www.sqlservercentral.com/Forums/Topic401633-217-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Index+Management/31911/">2005 Clean Indexes For All Databases on a Server</A>[/B]Sun, 23 Sep 2007 10:59:34 GMTGrant Fritchey