• If the TRY fail it goes into the CATCH, it does a rebuild.

    But it still updates the history table with “REORGANIZE & UPDATESTATS”

    Hi F.L

    Thanks for your information.I ll change this ASAP.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/