• Only GO command 🙂

    I also originally thought there is something extra in text and therefore hard printed whole SP- nothing

    Funny enough but when I tried to reproduce error I cannot do it.

    I do not mean to rerun whole SP- too expensive for 100 indexes.

    But after whole SP for 100 indexes was run and I got error I updated couple indexes (last in the ORDER by ID) completion flag (is_done = 0). Then I started SP again- it suppose to rebuild only these 2 indexes. Guess what? No error.

    But every week when all indexes were rebuilt- same story- SP completed successfully but same error returned every time

    Thanks,

    Yuri