Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
Similar to audit table script by Christopher this procedure is used to keep track on every single action on table. In addition, it keep old and new values, the name of the current security context as well as system date/time.
Once when you execute this SP against some user table it will create table prefixed with jrn_<table_name> and trigger on original table.
Once when you have journal table it's quite easy to make audit scipt like this one which return list of updated records (with print out of changed fields only).