sys.routes (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This catalog views contains one row per route. Service Broker uses routes to locate the network address for a service.

Column nameData typeDescription
namesysnameName of the route, unique within the database. Not NULLABLE.
route_idintIdentifier for the route. Not NULLABLE.
principal_idintIdentifier for the database principal that owns the route. NULLABLE.
remote_service_namenvarchar(256)Name of the remote service. NULLABLE.
broker_instancenvarchar(128)Identifier of the broker that hosts the remote service. NULLABLE.
lifetimedatetimeThe date and time when the route expires. Notice that this value does not use the local time zone. Instead, the value shows the expiration time for UTC. NULLABLE.
addressnvarchar(256)Network address to which Service Broker sends messages for the remote service. NULLABLE.
mirror_addressnvarchar(256)Network address of the mirroring partner for the server specified in the address. NULLABLE.

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Community Additions