I have a scenario here:

On my TEMPDB, the log reuse wait description shows " Active_transaction".

Then I checked DBCC OPENTRAN('tempdb') . I got message showing there are no open transactions. Then I also queried:

select * from sys.dm_tran_active_transactions

I see some four 6 worktables. I don't know about these tables. Now how can I change my tempdb state to "Nothing".