title: Looking at SQL Server Execution logs ideally verbose for debugging
body: <p>I was wondering if there is any way to check the execution logs of SQL server. I am not talking about the proprietary transactions logs or the error logs. But just the recently executed logs in a verbose fashion for debugging.</p>
  
  <p>For example, I have a web application that calls stored procedures, passes in parameters and populates gridviews etc. In the SQL management studio, I want to see (either through a log file or by running a T-SQL query) what stored procedures or sql statements were executed, what the value of the passed in parameters were and what the returned values were etc.</p>
  
  <p>Thanks in advance for your help.</p>