1. How to get the old value and new value updated ?
2.How to get all the chages of the table? eg . address they have update four time then we can see four time value.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jan 17, 2014, 3:16 AM
In this case CDC can help you
Please refer my article
http://www.c-sharpcorner.com/UploadFile/ff2f08/change-data-capture-cdc-in-sql-server-2008/
Biswa Pujarini MohapatraPosted Jan 16, 2014, 9:40 PM
you can enable "Audit trail" feature of Sql server find below references
http://stackoverflow.com/questions/17546601/best-way-to-implement-an-audit-trail-in-sql-server