We’ve managed to complete the all the integration from our current systems (Celcat and Sits),  so we now have a completed view of the student time table and changes.

From that we’ve been able to create a messaging table which so far stores messages on time table changes. Based on this messaging table we’ve created a draft RSS feed and an email broker using database mail in SQL Server 2005.