SqlCacheDependency via Service Broker Notification in a WebEdition of SqlServer 2008 R2

Question

I would appreciate Your help:

We are planing to buy SQL Server 2008 R2 Web Edition (we must this version), however we would also like to use a functionality of Service Broker for SqlCacheDependency - Notification Mode (NOT polling mode).

On msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx is said that Web Edition support for Service Broker (messaging) is : "Client only" - so some kind of short version.

Our server-environment is:

• one Http server with two web-application
• one DataBase server with single instance of SQL Server 2008 R2 Web Edition.

The idea is that: when new record is added to database table, sql server should notify both web-apllications and reset their caches (so we will have two integral caches). We are not planing to create a distributed cache (MemCache or sth)

Is there any way to combine these two demands (SqlCacheDependency via Service Broker Notification in a WebEdition of SqlServer 2008 R2) ? Buy a module, or some server architecture tricks. Any ides ?

Thanks in advance.

Answer 1

any one has ideas?