Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.