An inconsistency was detected during an internal operation in database 'tempdb'

Also if you lost the "Tempdb" tables, all what you have to do is restart the SQL server as the Tempdb" tables created each time you restarting the SQL server.