sys.routes (Transact-SQL)
This catalog views contains one row per route. Service Broker uses routes to locate the network address for a service.
Column name |
Data type |
Description |
|---|---|---|
name |
sysname |
Name of the route, unique within the database. Not NULLABLE. |
route_id |
int |
Identifier for the route. Not NULLABLE. |
principal_id |
int |
Identifier for the database principal that owns the route. NULLABLE. |
remote_service_name |
nvarchar(256) |
Name of the remote service. NULLABLE. |
broker_instance |
nvarchar(128) |
Identifier of the broker that hosts the remote service. NULLABLE. |
lifetime |
datetime |
The 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. |
address |
nvarchar(256) |
Network address to which Service Broker sends messages for the remote service. NULLABLE. |
mirror_address |
nvarchar(256) |
Network address of the mirroring partner for the server specified in the address. NULLABLE. |
Permissions
In SQL Server 2005 and later versions, 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.