Route without service name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mikhail Berlyant - 07 Mar 2007 21:55 GMT

In BOL under "Service Broker Routing" there is rule#5 under "Finding Matching Routes"
5. Find a route that does not specify either the service name or the service broker identifier.

I am trying to create route without service name and with just broker_instance specified as in example below:
CREATE ROUTE [ServiceName] WITH BROKER_INSTANCE = <broker_instance_identifier>', ADDRESS = N'TCP://ServerName:4022'

I am getting error:
Cannot specify BROKER_INSTANCE without SERVICE_NAME in route "TEST_myspace4".

Any idea,

Thanks,
Mikhail Berlyant
Senior Data Architect

Reply to this Message

Remus Rusanu [MSFT] - 07 Mar 2007 23:25 GMT

If you specify a broker instance then the service name is required.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

HTH,
~ Remus Rusanu

SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx

In BOL under "Service Broker Routing" there is rule#5 under "Finding
Matching Routes"
5. Find a route that does not specify either the service name or the service
broker identifier.

I am trying to create route without service name and with just
broker_instance specified as in example below:
CREATE ROUTE [ServiceName] WITH BROKER_INSTANCE =
<broker_instance_identifier>', ADDRESS = N'TCP://ServerName:4022'

I am getting error:
Cannot specify BROKER_INSTANCE without SERVICE_NAME in route
"TEST_myspace4".

Any idea,

Thanks,
Mikhail Berlyant
Senior Data Architect

Reply to this Message

Mikhail Berlyant - 07 Mar 2007 23:32 GMT

Thanks Remus
So, BOL is just "erroring" about rule #5 or it is expected feature in next
release?

Thanks,
Mikhail

> If you specify a broker instance then the service name is required.
>
[quoted text clipped - 17 lines]
> Mikhail Berlyant
> Senior Data Architect

Reply to this Message

Remus Rusanu [MSFT] - 08 Mar 2007 01:39 GMT

I think is a typo. It should read "5. Find a route that does not specify
either the service name nor the service broker identifier."
The MSDN/BOL have feedback options to notify the author of the content about
mistakes, if you use that it will get looked at.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

HTH,
~ Remus Rusanu

SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx

> Thanks Remus
> So, BOL is just "erroring" about rule #5 or it is expected feature in next
[quoted text clipped - 24 lines]
>> Mikhail Berlyant
>> Senior Data Architect

Reply to this Message

Remus Rusanu [MSFT] - 08 Mar 2007 01:45 GMT

/sigh , slow day....
It should read:

"5. Find a route that does not specify a service name nor a service broker
identifier."

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

HTH,
~ Remus Rusanu

SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx

>I think is a typo. It should read "5. Find a route that does not specify
>either the service name nor the service broker identifier."
[quoted text clipped - 29 lines]
>>> Mikhail Berlyant
>>> Senior Data Architect

Reply to this Message

Alan Brewer [MSFT] - 08 Mar 2007 18:34 GMT

I went ahead and filed a feedback bug to track this.

Signature

Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

oj - 08 Mar 2007 10:22 GMT

myspace != yourspace. ;-)

didn't know you've to myspace. kewl.

Signature

-oj

Reply to this Message