title: Service Broker required port
body: <p>Does anyone know if there is a port that absolutely has to be open on the SQL server to allow service broker traffic? We were testing what happens when you close off all ports on the SQL server except (1433, 445, 3389) and the query notification still worked. We were under the impression that 4022 has to be open for the service broker to work we a default listening port.</p>
  
  <p>Is there a SQL system view that shows what port the service broker is communicating on?</p>
  
  <p>Is there a command to terminate all active query notifications on a database so the database can be dropped?</p>
  
  <p>Thanks</p>