Endpoints

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Cantley - 13 Dec 2007 22:09 GMT

I have a service broker setup by a previous consulting company. I do not
have the scripts that created any of it but have gone through the service
broker setup. What I cannot figure out is how to determine what port the
endpoint is monitoring.

I do a query against sys.endpoints and get this. How can I determine the
port and any of the other stuff I need for a create endpoint?

Name: ServiceBrokerEndPoint
endpoint_id: 65536
principal_id: 1
protocol: 2
protocol_desc: TCP
type: 3
type_desc: SERVICE_BROKER
state: 0
state_desc: STARTED
is_admin_endpoint: 0

Reply to this Message

Adam Machanic - 13 Dec 2007 22:23 GMT

Try:

select port
from sys.tcp_endpoints
where type_desc = 'SERVICE_BROKER'

Signature

Adam Machanic
SQL Server MVP - http://sqlblog.com

Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220

>I have a service broker setup by a previous consulting company. I do not
>have the scripts that created any of it but have gone through the service
[quoted text clipped - 14 lines]
> state_desc: STARTED
> is_admin_endpoint: 0

Reply to this Message