Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Service Broker

Service Broker in Express edition

I'm trying to figure out if I can use express edition for service broker. Documentation says it can be used as Subscriber only -- but what does that mean? Can it only be a target for service broker messages? Or can it send messages as well as long as the other end of the conversation is a licensed server?

thanks!

[324 byte] By [PugV] at [2008-1-10]
«« Can't post to forum when ZoneAlarm is running
»» XI and VS 2005
# 1
Its the latter, one end of the dialog must be Workgroup, Std or Ent SQL Server SKU.

-Euan

EuanGarden at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Service Broker...
# 2
Just wanted to clarify that the only requirement is that at least one of the brokers on a route must be running on a paid version of SQL Server. This means that it doesn't have to be one of the endpoints; a paid forwarding broker works just fine.
Later,
Rushi
RushiDesai at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Service Broker...
# 3
Does that mean Service Broker cannot be used in Express even if the message never leaves the database? Can it stil be used for intra database actions?
AaronAnderson at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Service Broker...
# 4
The limitation only applies if messages have to be exchanged between two separate SQL instances. If the 'from' service and 'to' service both are in the same SQL instance (even on different databases), there is no limitation.
RemusRusanu at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Service Broker...
SQL Server
SQL Service Broker

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified