SQLTeam.com | Weblogs | Forums

Please hep : Data Archiving

I wanted to implement a data archiving solution.

Main table and the table to be archived will be two columns in a configuration table.

I would like to archive the data from main table(MainTbl) to archive table(ArchiveTbl), but archive table will have some additional fields (Archive ID, updated date, Updated User).

How can I achieve this dynamically as configuration table will have more tables to be archived.

Thanks,