将 Service Broker 与 Sql Server Express 2008 结合使用

问题描述:

是否可以在不通过 sql 企业/标准的情况下在 sql express 上使用外部激活?

Is it possible to use external activation on sql express without going thru sql enterprise/standard?

我想向 sql express 服务代理发送一条消息,然后让它通知我在同一台机器上运行的外部应用程序服务,以便启动控制台应用程序来接收消息并进行处理.我已经从远程 Sql Enterprise db 成功地做到了这一点.

I would like to send a message to sql express service broker, then have it notify my external application service running on the same box, in order to kick off a console app to pickup the message and process it. I do this already successfully from a remote Sql Enterprise db.

但现在我需要在一个带有 Sql express 的盒子中包含所有内容,而不使用远程 Sql Enterprise.

But now I need everything self contained on one box with Sql express, without using the remote Sql Enterprise.

但是 sql express 有局限性,所以我想知道是否可以按照独立配置中的描述使用 sql express,而无需通过 Sql Enterprise.感谢您的帮助!

However sql express has limitations so I'm wondering if I can use sql express as described in a stand alone configuration, without going thru Sql Enterprise. Thanks for your help!

你可以这样做,只要发送消息的盒子是非快递版.

You can do that, as long as the box sending the message is non-express edition.

Service Broker 与版本相关的限制是一条消息在从发送服务到接收服务的途中必须至少经过一个非快递实例.外部激活器服务本身.

The edition-related limitation of Service Broker is that a message must go through at least one non-express instance on its way from the sending service to the receiving service. There are no limitations on the External Activator service itself.