Hi Friends...
sometimes we execute wrong query or unwanted queries in database If you want to change it so you can get these last executed queries using the following SQL queries
sometimes we execute wrong query or unwanted queries in database If you want to change it so you can get these last executed queries using the following SQL queries
Your Queries are as under
1. 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
2. SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.*
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('msdb')
ORDER BY deqs.last_execution_time DESC
Thank You !
Thank You !
0 comments:
Post a Comment