I have an audit table in a SQL database that is structured like the one below: audit_id id location location_sub location_status dtm_utc_action action_type 2144 2105 9 1 1 2022-09-08 12:36 i 4653 2105 9 1 1 2022-09-08 13:53 u 7304 2105 10 2 2 2022-09-13 15:51 u 7326 2105 11 1 2 2022-09-14 10:06 u I’m trying to write a
Tag: audit
T-SQL Trigger – Audit Column Change
Given a simple table, with an ID what is the correct way to audit a column being changed. I am asking after looking after various answers which seem not to be working. Here is what I have: Create …
How to assign the IDs to the referring table and how to display this correctly? (SSMS)
I am in the process of creating an audit plan using ERD, going off the below image you can see that there’s a permissions table with four FK columns referring to the other four tables PK column. I am just confused as to how the IDs will relate to the other tables and how will it show up correctly in