Any Example on How to use Triggers in Web Application Project

Question

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

Muralidharan Deenathayalan · Answer

Aamir 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/