Show the current running SQL query on SQL Server

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time,
req.database_id,
DB_NAME(req.database_id) as DBName
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
where database_id = xxx

Get Database ID from name and vice versa

select DB_NAME(9) as DBName
SELECT DB_ID(N'DatabaseName') AS [DatabaseID];