Make sense, thanks

But what confuses me is that ALL statements completed successfully (i.e. seems no single failed)

I saw some posts regarding mysterious syntax errors that were results of different DBs compatibility level (CL)- certainly not sure it's my case. SP runs on DB with CL 100 (2008) but some of affected indexes live on DBs with CL 80 and 90 (i.e. 2000 and 2005).

But frankly I have no idea how it can result in this error

Thanks,

Yuri