Feature or Bug?

Service Broker will let you create two services with the same name (one with contract and another without)

CREATE SERVICE [Order Msg Recieve] AUTHORIZATION [dbo] ON QUEUE [dbo].[Order Return Msg Queue]

CREATE SERVICE [Order Msg Receive] AUTHORIZATION [dbo] ON QUEUE [ODS].[Order Return Msg Queue] ([OrderSubmission])

When you delete the service....

drop service [Order Msg Recieve]

It will only drop the first one. In the BOL there is no syntax for telling it to delete the second one, however you can drop it from SQL Management Studio.

I stumbled over this by accident. Just FYI

Gary

Neither feature nor a bug. Typo. One service is named 'Receive', one is named 'Recieve'. Note the 'cei' vs. 'cie'.

HTH,
~ Remus

sql