Last post Apr 26, 2018 04:57 AM by ryanbesko
Apr 26, 2018 04:54 AM|shallubhalla|LINK
My requirement is to make Audit table something like having columns FieldName,oldValue,NewValue,TableName,PK_id ,Action.
I want log of any insert/Update in multiple table using trigger.
Apr 26, 2018 04:57 AM|ryanbesko|LINK
Google is a better place to find answers. What you want is Change Data Capture (CDC). Manually written Triggers are not the way to go. Come to this forum when you've wrote some code and get stuck.
EDIT: You also put this in the Oracle, MySQL, Sybase, Informix and other databases forum. There is a separate forum for SQL Server.