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?