Online Documentation for SQL Manager for SQL server
A Route is a non-schema object which can be added to the routing table for the current database. For outgoing messages, Service Broker determines routing by checking the routing table in the local database. For messages on conversations that originate in another instance, including messages to be forwarded, Service Broker checks the routes in msdb.
Route Editor allows you to define route properties. It opens automatically when you create a new route and is available on editing an existing one.
To open a route in Route Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing route
- Browsing object dependencies
- Viewing DDL definition