 <p>If you are on SQL Server 2008, then you can try Change Data Capture which will allow you to pick up a Delta of changes every time.</p> <p><a href="http://msdn.microsoft.com/en-us/library/cc645937.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/cc645937.aspx</a></p>