• On SQL 2005, you will be surprised that reindexing a temporary table can cause this error.

    I have tested this on other versions like 2012 and it does not arise.

    I guess something is causing some kinda data change on an object which is resident on TempDB while the data is being referenced by a transaction, hence the error.