历史表优点、缺点和陷阱——使用触发器、sproc或应用程序级别

I am currently playing around with the idea of having history tables for some of my tables in my database. Basically I have the main table and a copy of that table with a modified date and an action column to store what action was preformed eg Update,Delete and Insert.I am currently playing around with the idea of