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

  • Right code to retrieve data from sql server database
  • SQL UK postcode matching query
  • the best way to connect sql server (Windows authentication vs SQL Server authentication) for asp.net app
  • best way to “glue” columns together
  • How to secure MS SSAS 2005 for HTTP remote access via Internet?
  • Wrapping and removing CDATA around XML
  • Just wondering if its possible to build a real time app that pushes notifications of table changes.

  • nvarchar column size impact on performance
  • Generate a repetitive sequential number using SQL Server 2008
  • View to identify grouped values or object
  • Avoid NULL columns using DEFAULT Empty String
  • Interpreting byte in stored procedure
  • How to combine results of two queries into a single dataset
  • 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

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.