title: Service broker queue message arrived but notification doesn't work
body: <p>I am using the External Activator provided by Microsoft to monitor service broker queue messages. The main queue's name is "ReportQueueTarget". I also set up a notification queue like this:</p>
  
  <pre><code>CREATE QUEUE ReportExternalNotifyQueue
  GO
  -- create event notification service
  CREATE SERVICE ReportExternalNotifyService
        ON QUEUE ReportExternalNotifyQueue
        (
              [http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]
        )
  GO
  
  -----------------------------------------------------------------------------
  -----------------------------------------------------------------------------
  -----------------------------------------------------------------------------
  
  CREATE EVENT NOTIFICATION [ReportNotification]
  ON QUEUE [ReportQueueTarget]
  FOR QUEUE_ACTIVATION
  TO SERVICE 'ReportExternalNotifyService','current database'
  GO
  </code></pre>
  
  <p>This works fine for the two environment I set up. However, for this new environment I am setting up now, message successfully arrive in the main queue, but nothing ever shows up in the notification queue. Therefore, the external activator never receives and notification. What could cause this problem?</p>
  
  <p>Thanks!</p>