• A quick Google search for "using triggers to track changes" yields many results

    http://www.philosophicalgeek.com/2008/05/13/tracking-database-changes-using-triggers/