title: SQL 'comment' that can be read in a sql profiler
body: <p>I've tried several methods such as using double hyphens, i.e. --THIS IS A COMMENT but when the executed sql is read in a profiler the comment is stripped out leaving only raw SQL that is being performed.</p>
  
  <p>I want to do this to enable rapid identification of queries and their origins when looking at a SQL Profilers output that has over 8000 entries per minute,
  so something like</p>
  
  <pre><code>--Method signature and an application name
  </code></pre>
  
  <p>e.g.</p>
  
  <pre><code>--MyMethod(string username) in MyFunkyAppName.
  </code></pre>
  
  <p>I'm using EntityFramework 4.3 which complicates things even further with linq to entities and a smattering of linq to sql thrown in for good measure.</p>
  
  <p><strong>EDIT</strong>: I'm aware of solutions to add a dodgy where clause or use anonymous properties to identify things such as <a href="https://stackoverflow.com/questions/316178/clever-tricks-to-find-specific-linq-queries-in-sql-profiler">Clever tricks to find specific LINQ queries in SQL Profiler</a> but I'm hoping for a far less hacky approach or perhaps a generic one.</p>