ukerandi
asked on
sql Audit table
Hi , I need to create audit Log, any user add any records to table what is old value and new value
For example
some one add employee Table
Audit Table
Empid employeeSalary Datechanged Createdby
1 20000 20/08/2015 ryan <------ Old Records
1 30000 25/09/2015 Stephen <----- New Records
After add new records
I need to do at least 50 tables.
Thanks
For example
some one add employee Table
Audit Table
Empid employeeSalary Datechanged Createdby
1 20000 20/08/2015 ryan <------ Old Records
1 30000 25/09/2015 Stephen <----- New Records
After add new records
I need to do at least 50 tables.
Thanks
Take a look at CDC.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks