Link to home
Start Free TrialLog in
Avatar of ukerandi
ukerandiFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of ste5an
ste5an
Flag of Germany image

Take a look at CDC.
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ukerandi

ASKER

thanks