select session_id,login_time,program_name,login_name,lock_timeout from sys.dm_exec_sessions
where lock_timeout > 0