This open source project (on CodePlex) shows how to use different technologies to display table changes as an RSS/Atom feed.
It uses the new Change Tracking feature in SQL Server 2008 together with WCF and LINQ to XML.

Check out the homepage and if you want to add some features to it feel free to contact the project owner.