 
     , PS.alloc_unit_type_desc 
 
-    , Max (partition_number) OVER(PARTITION BY IDX.object_id, IDX.index_id) as TotPartNb
-
     , (
 
       select top 1 SC.name from sys.columns SC 


   

End -- Upgrade.FailoverForUpgrade

go



          Then '

                ALTER INDEX [<idx>] ON [<DbName>].[<scn>].[<tb>] Rebuild;

                '

