title: Is it possible to get the queries executed in the past?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5299669/how-to-see-query-history-in-sql-server-management-studio">How to see query history in SQL Server Management Studio</a>  </p>
  </blockquote>
  
  
  
  <p>I want somehow to get the history of the executed queries on SQL Server 2008 R2. Let's say I run the query:</p>
  
  <pre><code>DELETE FROM TABLE
  </code></pre>
  
  <p>Is it logged somewhere? Can I see the queries that were executed on the server? </p>
  
  <p>I want to check if a stored procedure or any other automated task was executed at a specific time.</p>