InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:28:14 GMT20http://www.sqlservercentral.com/Forums/Topic711029-146-1.aspxHi,Take a look at the following [url=http://www.johnsansom.com/index.php/2009/03/automate-sql-server-index-defragmentationoptimisation/]article[/url], it contains a reference to one of the best index rebuild scripts there is. When the stored procedure encounters a partitioned index, it performs a specific action. [url=http://www.johnsansom.com/index.php/2009/03/automate-sql-server-index-defragmentationoptimisation/][u]Index Optimisation Script Link[/u][/url]See procedure snippet below that identifies the partitioned indexes.[code] /* Determine if the index is partitioned */ SELECT @partitionSQL = 'Select @partitionCount_OUT = Count(*) From ' + @databaseName + '.sys.partitions Where object_id = ' + CAST(@objectID AS VARCHAR(10)) + ' And index_id = ' + CAST(@indexID AS VARCHAR(10)) + ';' , @partitionSQL_Param = '@partitionCount_OUT int OutPut'; [/code]I'm certain you could easily modify the stored procedure and/or code to suit your needs.Cheers,Wed, 06 May 2009 08:27:46 GMTJohn.Sansomhttp://www.sqlservercentral.com/Forums/Topic711029-146-1.aspxHi All,Can anyone help on getting a scripts to rebuild index for all db's except the Partitioned table indexes. Thanks in Advance,GaganWed, 06 May 2009 07:07:43 GMTgaganks