http://www.sqlservercentral.com/Content tagged Database Design, Auditing posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)My company is just starting to look at adding functionality to retain historical data for key tables and columns for auditing purposes in many of our SQL Server databases. I have seen some of your recent tips related to triggers (Forcing Trigger Firing Order in SQL Server and Trigger Alternatives in SQL Server - OUTPUT Clause). Based on using triggers or a similar technology, what is the best way to store the historical data?http://www.sqlservercentral.com/redirect/articles/62769/2008/04/15http://www.sqlservercentral.com/redirect/articles/62769/