Best Option Needed

[cyrus]

I have a number of tables created in SQL server and many operations are carried out daily on these tables. I want to create one more table to keep track of the changes or updations carried out on these tables with time recorded in this. Will a mirror table needed to be created for each of the table to keep track of updations or changes. Kindly suggest a best option for this process?

[caradoc]

It is a good option to create mirror table which is technically called as audit table to keep track of the changes or updations carried out on these tables with time also recorded in this. But before doing this just spend some extra time on designing tables and see which tables really need audit tables. Don’t create unnecessary audit tables for all tables.