Jason

You're only running one ALTER INDEX statement at a time, so it doesn't make any difference whether you use an explicit transaction or not. I think what Lynn was asking in the other thread was whether the whole WHILE loop was enclosed in an explicit transaction.

John