Click here to Skip to main content
15,881,424 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Is it possible to monitor the changes done to the backend tables when the user modifies any data?
How can i maintain a history table to track the modified changes with the old data.?
Is there any way of procedure to track the changes done by the user from front end. As they are given the provision to modify the existing data.


Please give me an idea of how it may work.

Regards,
Priya.
Posted
Updated 14-May-12 22:12pm
v2

1 solution

Yes, possible. It is tracked using Audit trail/Audit history tables.
You populate these tables based on update/delete/insert triggers on other tables which you want to track.

Following article should help you:
Audit Trail Generator for Microsoft SQL[^]
MSDN: CREATE TRIGGER (Transact-SQL)[^]
 
Share this answer
 
Comments
VJ Reddy 15-May-12 4:50am    
My 5!
Sandeep Mewara 15-May-12 12:02pm    
Thanks.

Off Topic: Last night, I published a Tip: http://www.codeproject.com/Tips/384425/Server-side-Delimiters-in-ASP-NET
Have a look and share your feedback.
VJ Reddy 15-May-12 13:11pm    
Seen. The tip and presentation is very good :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900