Dear Friends,
I have a requirement when a person insert some data throug a Web form,
then his details must be capture in a Table....and next time who ever changes the data then his details must be logged in a Log table...by which Admin will come to know who has created the data and who change it later.
what has to be done in Web form or Database???
please let me know.
Regards,
Aamir
Loading
Posted Jun 19, 2012, 11:26 AM
Basically you have to do auditing on your data.
You can write your own methods to compare the old and the modified data. If there is any modification, insert the old data into separate table and who done the modification with datetime stamp.
http://stackoverflow.com/questions/349524/sql-server-history-table-populate-through-sp-or-trigger
http://stackoverflow.com/questions/793643/auditing-sql-server-data-changes
http://sqlserver2000.databases.aspfaq.com/how-do-i-audit-changes-to-sql-server-data.html
http://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/
You can use DoddleAudit also.
http://doddleaudit.codeplex.com/