Home Forums SQL Server 2008 SQL Server 2008 - General Logging field changes in table using triggers or service broker RE: Logging field changes in table using triggers or service broker
ESAT ERKEC
SSCertifiable
Points: 5661
More actions
November 27, 2012 at 5:20 am
#1562610
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