title: SqlDependency dependency_OnChange Info "Query"
body: <p>I have a very frustrating problem.  My .net 4 app has been successfully using the <code>SqlDependency</code> object for some time to receive INSERT or UPDATE notifications from SQL server.  </p>
  
  <p>However the database it receives notifications from has just been updated (it is the back end  to a 3rd party app so I don't know what the update entailed) and now when I restart my <code>SqlDependency</code> app it does not behave properly.  During the <code>StartSQLDependency()</code> method this line triggers the <code>dependency_OnChange</code> event: </p>
  
  <pre><code>using (SqlDataAdapter adapter = new SqlDataAdapter(_SqlCommand))
      adapter.Fill(_datatable);   
  </code></pre>
  
  <p>With <code>SqlNotificationEventArgs</code>:</p>
  
  <pre><code>e.Info "Query"
  e.Source "Statement"
  e.Type "Subscribe"
  </code></pre>
  
  <p>Previously I had only seen:</p>
  
  <pre><code>e.Info "Update" or "Insert"
  e.Source "Data"
  e.Type "Change"
  </code></pre>
  
  <p>Can anyone please suggest what my have changed in the database to cause this?</p>