Finding which Database is selected.

SELECT db_name(dbid) as [DB_Name],
count(dbid) as No_Of_Connections,
loginame as Login_Name
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid,loginame;