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 ?