This should do it
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;
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events