A great concept, excellently packed and ready for use out-of-the-box.

Reading the article sparked off an idea but, as I'm relatively inexperienced in working with SQL server & XML, I'm not sure if this would be possible. Anyway here is the idea.

In applications that I have worked on there has been a need, especially in the area of master data (codes, descriptions, customers account information etc.), to record who changed what data and when. Something that can take as much effort to do as to maintain the information itself.

Extending the data collected to include the who & the when will allow the rollback, rollforward of data on a user basis and solve the business auditing need in one and the same solution.

I'm assuming that the system tim & the logged on user (not necessarily the db user) are available as either variables or function calls.

To me, this almost seems too good to be true. There must be a catch somewhere or what?