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