Auditing data changes

Great post about using the output command to capture data changes when running update statements.  A nice alternative when backing up the entire table isn’t that great of an option.

http://www.sqlservercentral.com/blogs/sqlstudies/2013/06/26/using-output-to-back-up-a-change/