Chandrashekar
7/13/2016 - 9:49 AM

Accidentally closed Sql Script

Accidentally closed Sql Script


SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery
CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
WHERE execsql.text LIKE '%@tblIncomingEngUserId%'
ORDER BY execquery.last_execution_time DESC