• I think triger is best solution in sql server 2005 i used it about 20 million record table logging

    but you can look at this

    http://sqlblog.com/blogs/linchi_shea/archive/2012/01/24/performance-impact-sql2008-r2-audit-and-trace.aspx