SQL Server database insert/update TCP notifications
Is there anyway to send some sort of message 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.
2 Solutions collect form web for “SQL Server database insert/update TCP notifications”
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