I have an application in Access 2007 with a SQL Server 2008 R2 backend. I would like to create a trigger in SQL Server that will record all changes that are made to a particular table. When an operator changes a data element in the table, I would like to record the "before" image of the changed row in the table (all columns including the ones that weren't changed) along with date, time, user login id, and, if possible, the form that was used to make the change. I would like another trigger that would remove all rows in the audit table that is, say, over 90 days old.
Thanks, Eddie