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?