Get Last SQL Statement executed in sessions

SELECT session_id as [Session ID], TEXT as [Last Activity Details]
FROM sys.dm_exec_connections
CROSS APPLY sys.dm_exec_sql_text(most_recent_sql_handle)