we need to report on what changes were made to one particular column of a table. We need to report the old value, the new value and the date and userid (these are also fields in the table).
I assume we use an update trigger with a query to capture the old and new values in a temp table?
Does anyone have any sample syntax for such a situation?