We want to be able to cache the data for our propertydetails web page (a real estate web site)
Right now the stored procedure for that page is not a good candidate for query notification.
Is it possible to have a trigger on a Property table and when the lastupdated field is changed then go and update the web cache data for that propertydetails page?
(i believe that this is Broker Services).
You'll probably receive more responses from another newsgroup or forum. This one is dedicated to SQL Server Notification Services - not the same technology as Query Notifications.
Cheers!
Joe
No comments:
Post a Comment