SQL Log Query


SELECT deqs.*, dest.*

FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

WHERE dest.TEXT LIKE '%update%'
AND deqs.last_execution_time = '2012-09-14 11:04:39.323'
ORDER BY deqs.last_execution_time DESC


Note: update is the Text of "desired query" in Log.


Related Posts Plugin for WordPress, Blogger...