SQL Server database insert/update TCP notifications

Is there anyway to send some sort of m开发者_C百科essage from SQL Server to identify that a table has been updated or had a record inserted into it? Preferably TCP but anything will do.

I know there is SQL Notification Services but this is no longer supported in SQL 2008

Just wondering if its possible to build a real time app that pushes notifications of table changes.

Service Broker and Query Notifications.

• Overview (Service Broker)

• Working with Query Notifications

• Query Notifications in SQL Server (ADO.NET)

You can try LinqToCache which allows to wrap a SqlDependency around any LINQ query, as long as the LINQ generated T-SQL is compatible with Query Notifications. It will work with .Net, not sure about node.js