Tracking who is changing what?

rrhandle · #1 (**permalink**) 08-09-06, 11:32

We are building an inventory management system complete with BOM. It is important to track what employee is updating what tables. Currently all such tables have a Date field that is updated when a change is made, and an EmployeeID field which records the employee making the change. I am wondering if someone knows of a better way to track this information. Any suggestions?

cfr · #2 (**permalink**) 08-09-06, 12:19

I'd use Lumigents Log Explorer if I was you.

Thrasymachus · #3 (**permalink**) 08-09-06, 12:51

Our application has History tables and triggers on the live tables that log every change to the table. 2 keys to making this work is to have date the change was made and an extra field on the history table that is an incrementing identifier.

rajeshpatel · #4 (**permalink**) 08-10-06, 00:23

We have following Fields...

(create) user name
created date-time
(last modify) user name
(last) modify date-time
machine name

It's depend on your accuracy requirement...

Brett Kaiser · #5 (**permalink**) 08-10-06, 14:00

Have a read over here

http://weblogs.sqlteam.com/brettk/ar.../10/11126.aspx