Is it possible to get the queries executed in the past?

Question

Possible Duplicate:
How to see query history in SQL Server Management Studio

I want somehow to get the history of the executed queries on SQL Server 2008 R2. Let's say I run the query:

DELETE FROM TABLE

Is it logged somewhere? Can I see the queries that were executed on the server?

I want to check if a stored procedure or any other automated task was executed at a specific time.

score 3 · Answer 1 · edited May 23 '17 at 11:55

3

Will this help?

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

and as pointed by anio How to see query history in SQL Server Management Studio

edited May 23 '17 at 11:55

Community

1
1

answered Aug 30 '12 at 14:43

Niladri Biswas

4,153
2
17
24

I've already seen that but it didn't help me. It returns the latest more often executed queries form the cache of the Sql Server. – chaliasos Aug 30 '12 at 14:50
sys.dm_exec_sql_text is not available in sql server 2000 and available from 2005 – Durai Amuthan.H Feb 12 '14 at 14:42

Is it possible to get the queries executed in the past?

1 Answers1