How do I determine the correct Database against which a blocking or non blocking query was run.

See more:

SQL

database

I have the following problem. I am trying to build a query to show blocking and non-blocking queries. I got a query from the Internet which uses master.sys.sysprocesses. When googling it I saw that it was depreciated. The Microsoft website says to rather use the following 3 tables.
sys.dm_exec_connections
sys.dm_exec_sessions
sys.dm_exec_requests
I amended my query to join these three tables on session_id column. Two of the Tables namely (sys.dm_exec_sessions,sys.dm_exec_requests) have a column called database_id which is use in the function DB_NAME(database_id) which gives me a name of a database.

However that database is not the database against which the query is run. For example. I use Microsoft Sql Server Management Studio to run a query which I run while connected to the master database however the query is a select and looks something like this.
SELECT ColumnA, ColumnB, ColumnC
FROM MyDatabase.MySchema.MyTable


When I then run the following query with the SPID of the above query :
select DB_NAME(database_id) from sys.dm_exec_sessions where session_id = @varSPID
select DB_NAME(database_id) from sys.dm_exec_requests where session_id = @varSPID

Where @varSPID is an integer variable of the first query. However it always just says [master] database instead of saying [MyDatabase]. What table can I use to determine the true table against which the query has executed ?