title: How to see variable values in SQL Profiler when Trigger fires?
body: <p>I am creating an "After Update" Trigger on a SQL Server 2008 table. The trigger fires just fine but one of the values it's updating in another table isn't correct. I am looking at a trace in SQL Profiler, but I can't see my variable's values in there. </p>
  
  <p>I read <a href="https://stackoverflow.com/questions/1952830/how-do-i-get-parameter-values-for-sql-server-query-in-sql-server-profiler">this other question</a> and so added the RPC: Completed Event to my trace, but there were not instances of that event in my trace for some reason. That is, I see it at other places in the trace but not where my trigger is firing. </p>
  
  <p>Just to (hopefully) be clear, my trigger is EXECUTING an SP like this: </p>
  
  <pre><code>EXEC SP_UpdateSomeStuff @variable1, @variable2
  </code></pre>
  
  <p>... and that's all that I see in the trace. What I wish to see is: </p>
  
  <pre><code>EXEC SP_UpdateSomeStuff @variable1 = 111, @variable2 = 222
  </code></pre>
  
  <p>... but I can't figure out which events to add to get this. Thanks for any ideas. </p>