title: get all executed queries in sql server
body: <p>I require is to have a single stored procedure which can execute 
  and show </p>
  
  <p>"all SQL for the current connection which has previously run" and "not currently running".</p>
  
  <p>I have searched a lot about this and I am not able to find the answer. Please help me on this.</p>