so i'm in position of using cache database. not decision, i'm coming project view of it's database, naysayers please respectable. there's on 24 million rows per year added database i'm looking way history on insert/update/delete. in sql server create database model, run tool generate history tables in database, , triggers insert/update/delete. e.g. [mydatabase].[dbo].[address], [mydatabasehistory].[dbo].[addresshistory]...you idea...anyone out there experience doing similar thing cache database?
in caché can use triggers, please see in documentation
