Using Service Broker with Sql Server Express 2008

Question

Is it possible to use external activation in sql express without switching to sql enterprise / standard?

I would like to send a message to the sql express service browser, and then notify my external application service running in the same field to start the console application to send the message and process it. I am doing this already successfully with remote Sql Enterprise db.

But now I need everything that is contained on the same box with Sql express, without using remote Sql Enterprise.

However, sql express has limitations, so I wonder if I can use sql express, as described in a separate configuration, without going through Sql Enterprise. Thank you for your help!

Answer 1

You can do this as long as the post field is not an expression.

A limitation associated with the Service Broker edition is that the message must go through at least one instance without expression on the way from the sending service to the receiving service. There are no service restrictions.