title: How to track CONTEXT_INFO in SQL Server Profiler?
body: <p>I am working with SQL Server 2008 R2. If I set some context info for the current session, how can I track it in SQL Server Profiler? Which column in SQL Server Profiler will show me the value of the context info?</p>
  
  <p>For example suppose in a stored procedure, I set context info to 'dev_support' this way:</p>
  
  <pre><code>declare @v_user_id varchar(100)
  declare @v_context_info varbinary(128)
  
  select @v_user_id = 'dev_support'
  select @v_context_info = CONVERT(varbinary(128), @v_user_id)
  SET CONTEXT_INFO @v_context_info
  </code></pre>
  
  <p>How to see the value 'dev_support' in SQL Server Profile?</p>
  
  <p>Thanks</p>