QUERY TO FIND ALL THE PROCESSES RUNNING ON PARTICULAR DATABASE

SELECT [Database]=DB_NAME(dbid), spid, last_batch,status, hostname, loginame

FROM sys.sysprocesses

WHERE dbid=DB_ID('SYSTEMTEST'); ----change the databse name here