Vikash p
asked on
Transaction History in SQL SERVER Express
I need to keep Table log in a history table. Can you please suggest me I can get the record from SQL SERVER Log table ?
Or do I need to write trigger for every table and store the data for edit, insert and delete in history table ?
Its a ASP .NET application so I want to store data about the user did the modification and from the IP . Whats the best way to do this ?
Or do I need to write trigger for every table and store the data for edit, insert and delete in history table ?
Its a ASP .NET application so I want to store data about the user did the modification and from the IP . Whats the best way to do this ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.