Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |