YOU NEED TO IDENTIFY THE TCP PORT NUMBER THAT YOUR SQL SERVICE BRO...

12. You need to identify the TcP port number that your sQL service

Broker endpoint is using. Which query will allow you to most easily

identify the TcP port number of the sQL server Broker endpoint?

A.

SELECT p.portFROM sys.tcp_endpoints as pJOIN sys.service_broker_endpoints as s ON s.endpoint_id = p.endpoint_id;

B.

SELECT p.portJOIN sys.endpoints as s ON s.endpoint_id = p.endpoint_id;

c.

SELECT p.portFROM sys.service_broker_endpoints p;

D.

SELECT p.portFROM sys.endpoints p