Finding out last running queries

select * from sys.sysprocesses p cross apply sys.dm_exec_sql_text(p.sql_handle) t