HI Friends,
Recently i have done Accounts Project.In that i don't done any Transation Log for any updation.Thats need for client in case of any moral activities.
I would have to track who done that transation , when , howmuch and for which id These information have to be track clearly.
How should i do professtionally ,Guide me
Thanks in Advance ,
-Ernesto Karthik
Loading

Ravi ShekharPosted Aug 3, 2013, 12:31 AM
Every day it should create a new txt and just append this txt till today date.
Riyaz AkhtarPosted Aug 2, 2013, 10:05 AM
Check below link:
https://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/
OR
You can use trigger :
see below link for details:
http://www.mssqltips.com/sqlservertip/2342/understanding-sql-server-inserted-and-deleted-tables-for-dml-triggers/
Iftikar HussainPosted Aug 2, 2013, 9:04 AM
You can use different loggin tool to do this. You EnterPrise Library logging. Please refer the below link
http://www.codeproject.com/Articles/9545/Get-Logging-with-the-Enterprise-Library
Regards,
Iftikar