Get Last SQL Statement executed in sessions

Ranjeet_8
Posted by Ranjeet_8 under Sql Server category on | Points: 40 | Views : 902
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)

Comments or Responses

Login to post response