The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'

You can search all the temp objects with a simple SELECT * FROM tempdb..sysobjects WHERE name LIKE '%Alltemptab%'
To fix it just run once:

BEGIN TRANSACTION
    DROP TABLE #Alltemptab
COMMIT TRANSACTION
If you still cant delete it just check for zombie sessions with SELECT * FROM sys.dm_exec_sessions and kill it with KILL session_id.