I'm currently in the process of creating an announcement system at my place of work. The role of this system will be to replace all users email due to people misusing it and generally abusing the facility. The system will consist of:
Web Portal: Will allow staff to enter any important announcements (this will be restricted via AD).
SQL Server 2k5 DB: Will hold the announcements along with records of staff members and if they've read the announcements etc.
Front End: Created in WPF & C# which is nearly complete, it will display the announcements to the users.
Web Page: Client will contact every so often, which will return an xml file for the client to read.
However my boss has now shifted the goal posts and would like the announcements to appear to the user once they are written to the database, rather than waiting on the client to contact the webpage.
So now I'm a bit unsure as to how to go about this. I have one idea where I would create a small server application to monitor for new announcements then contact the clients to inform them to approach the website for the information they need. But I'm just looking to see if theres a better or more efficient way to do this or if someone else has a more appropriate idea or suggestion.