Recover SQL statements

Recover MS SQL statements which get deleted/closed accidentally

 SELECT
     deqs.last_execution_time AS [Time], 
     dest.TEXT AS [Query]
  FROM 
     sys.dm_exec_query_stats AS deqs
     CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest 
 WHERE dest.dbid = DB_ID('YOURDATABASENAME')
 ORDER BY deqs.last_execution_time DESC

OR

SELECT
     deqs.last_execution_time AS [Time], 
     dest.TEXT AS [Query]
  FROM 
     sys.dm_exec_query_stats AS deqs
     CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
 ORDER BY 
     deqs.last_execution_time DESC

Returns query with time.

GAURAV

,
, , , , ,