• SQL 2008 R2 - Change Tracking may help you...

    http://msdn.microsoft.com/en-us/library/cc280462(v=sql.105).aspx