Now, I have an application in SQL Server 2008 that consists of a database and several services. One of the services adds information to the database (which is triggered by a user).
Another service queries the databases for changes and uses the new data for processing.
I used a configurable timer that queries the database every
30 seconds or so. In SQL 2005, it featured a notification of
changes. But in SQL 2008, the feature is gone.
What is the best way of getting notified of these changes?