![and transcad syntax and transcad syntax](https://slidetodoc.com/presentation_image_h/cf97670c14dead004542456db2904da6/image-6.jpg)
The broker_instance_identifier parameter must be the broker instance identifier for the remote database, which can be obtained by running the following query in the selected database: SELECT service_broker_guid Specifies the database that hosts the target service. A route to this service might not specify a broker instance.īROKER_INSTANCE = ' broker_instance_identifier ' A route with a service name of 'SQL/ServiceBroker/BrokerConfiguration' is a route to a Broker Configuration Notice service. If the SERVICE_NAME is omitted, this route matches any service name, but has lower priority for matching than a route that specifies a SERVICE_NAME. In other words, the comparison is case sensitive and does not consider the current collation. Service Broker uses a byte-by-byte comparison to match the service_name. The service_name must exactly match the name the remote service uses. Specifies the name of the remote service that this route points to. Introduces the clauses that define the route being created. When this clause is omitted, the route belongs to the current user.
![and transcad syntax and transcad syntax](https://slideplayer.com/slide/4320620/14/images/66/TransCAD+Turn+Movement+Forecasts.jpg)
Otherwise, owner_name must be the name of the current user, the name of a user that the current user has IMPERSONATE permission for, or the name of a role to which the current user belongs. The owner_name can be the name of any valid user or role when the current user is a member of either the db_owner fixed database role or the sysadmin fixed server role. Sets the owner of the route to the specified database user or role. Server, database, and schema names cannot be specified. A new route is created in the current database and owned by the principal specified in the AUTHORIZATION clause. Transact-SQL Syntax Conventions Syntax CREATE ROUTE route_name For messages on conversations that originate in another instance, including messages to be forwarded, Service Broker checks the routes in msdb. For outgoing messages, Service Broker determines routing by checking the routing table in the local database. Adds a new route to the routing table for the current database.