Is it possible from SQL Server to notify process or applications connected to a certain database that a new record has been added to a certain table? Sample Scenario. Client A,B, and C are connected to the same DB. Client A adds a new record to the database. SQL Server must notify Client B, and C (a message or something) that they must update/or get a new dataset to be able reflect the new record added.

Your ideas will be of great help..