title: SqlDependancy does not work
body: <p>I am trying to create a SQLDependency for enterprise library, there is something strange that onChange event never fired.
  <br /> <br /> 
  For SQLServer2005: <br />Service Broker is enabled. <br />CLR integration is enabled.
  <br /></p>
  
  <p>The query is a simple select statement on user defined table, the query is wrapped in sproc.
  <br /> </p>
  
  <p>I have been told that I should find the notification status in sys.transmission_queue table, but it is empty, it seems that no notifications were made.</p>
  
  <p>What is chances?</p>
  
  <p>Thanks</p>