Is there a good way to track changes to records in a table for auditing purposes? I would like to automatically add a log in a table when a user either edits or deletes a record for data auditing purposes. It should log values of old data and UserID of the user performing the action.
Is this something that I need to setup at the "application" level (probably at the data access layer) instead of at the "database" level?
It's "my" world. You're just living in it.