Find query list from date to date

• Sharon Kumar

  Ten Centuries

  Points: 1193

  More actions

  August 18, 2010 at 10:28 am

  #239163

  Hi can any one help to find the query list which ran from particualar date to dar..

  this query return me recent transaction, i need from particular date to date.

  SELECT *

  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

  please help on this

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  August 19, 2010 at 12:22 am

  #1208905

  there is a column "last_execution_time", check with it

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)