Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
steve gray 8/9/2011 7:24:59 AM

Table Auditing

Editors Note:

There is a more recent version of this script here: http://dyndeveloper.com/ArticleView.aspx?ArticleID=4015

Auditing SQL tables is a very basic concept. You ocassionally need to save all changes to a table so that you have some history of the changes.

This script creates an audit table and triggers for the specified table.

Run the script against any table and an audit table will be created with the same name as the source table + 'AUDIT'. So auditing 'myTable' creates 'myTableAUDIT'.

We also create insert, update, and delete scripts that will populate the table.

You'll also need this script: http://dyndeveloper.com/ArticleView.aspx?ArticleID=1707

 

 

Version: Unknown or N/A
Section: SQL Scripts








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables