Hello Smith,

Can you check whether this query gives out the desired results you want?

select es.session_id, sp.spid, sp.dbid, object_name(dbid)

from sys.dm_exec_sessions es inner join sys.sysprocesses sp on es.session_id = sp.spid

Thanks

select
    es.session_id,
    er.session_id,
    er.dbid,
    db_name(er.dbid)
from
    sys.dm_exec_sessions es
    inner join sys.dm_exec_requests er on es.session_id = er.session_id;

select
    es.session_id,
    er.database_id,
    db_name(er.database_id) AS DBName
from
    sys.dm_exec_sessions es
    inner join sys.dm_exec_requests er on es.session_id = er.session_id;