I'm developing a database application by C# in which users can contact to the SQLServer 2008 (installed on a server dedicated for SQLServer 2008) over small lan Network. The users send and retrieve their data from the database in a normal way. Some users' tasks depend on some data that must be entered by another users. So, my question is:
When users send their entered data to the SQL database, is there a way to make SQL database itself automatically send updates to the meant users who need to know these information?
For example, when a user1 entered new customer data, and send these data to the SQL database, thus SQL database itself automatically send updates to user4, user6, user10 computers (just the meant users)..
Is this possible? and how?
Thanks for helping..
What I have tried:
Really, I don't know how to do it..