sql 查询所有会话

SELECT *
FROM (SELECT *
FROM SYS.sysprocesses WHERE spid>50 ) A CROSS APPLY SYS.dm_exec_sql_text(A.sql_handle) order by [text]