I am looking for the proper architecture for solving the real time appointment scheduler application. All clients will be connected to the server hosted with SQL Server 2000/2005/2008. Any changes of appointment data, the clients will get the notification from the server. The client will pull/refresh the data for the user interface.
Any article/source code/ recommeded architecture are much appreciated.