title: How do I get parameter values for SQL Server query in SQL Server Profiler
body: <p>I'm trying to analyze a deadlock in SQL Server 2008 profiler. I know how to find the offending sql queries, but the collected queries do not include parameter values. </p>
  
  <p>I other words I can see something like this:</p>
  
  <pre><code>DELETE FROM users WHERE id = @id
  </code></pre>
  
  <p>But what I would like to see is this: </p>
  
  <pre><code>DELETE FROM users WHERE id = 12345
  </code></pre>
  
  <p>I guess there are some additional events or Columns I need to collect in the profiler, but I don't know which. I am currently using the "TSQL_LOCKS" template. </p>
  
  <p>Any hints would be greatly appreciated. </p>
  
  <p>Thanks,</p>
  
  <p>Adrian</p>
  
  <p>Disclaimer: I've asked a similar question before, but I guess it was too specific, which is why I got no replies. I'm starting another attempt with this one.</p>