I need to know if this is possible to do with MS SQL Server 2008 and if it is, if someone could point me to how to accomplish this.
1. Have a couple .net clients connect to a database.
2. Each .net client "subscribes" to events that are created when a row is inserted into a particular table.
3. One client inserts a row into that table and an event is triggered on SQL Server and reaches all clients.