Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

Table journal

By Boka,

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).

Total article views: 1702 | Views in the last 30 days: 3
 
Tags
auditing    
journal    
triggers    
 
Contribute