Then you'll also be happy to know many tables have a DateLastTouched column, also.

However, two columns such as those provide for a very weak audit trail as they cannot track multiple events - just the last one. Fortunately, Amazing Charts does what I consider to be a very good job of auditing changes to tables compared to many other softwares I've seen.

The AuditLog and AuditTrail tables are where the real fun is if you want to know who is doing what.

JamesNT


James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net