arsinfor (5/24/2011)
I'm looking for the most eficcient way to audit the changes on a particular table. Generaly you need to know which table, row and column where changed. I mean the option is triggers but expend very much time to create one by one on each table. Also we need to check inserted against deleted temp row column by column...Does exist another way?
Hi arsinfor,
If you are using SQL 2008, then I believe the new change tracking features could be useful given your requirements.
http://msdn.microsoft.com/en-us/library/cc280462.aspx
However, once you start to talk about custom logic based around inserted/deleted rows, then I think you are in trigger territory.
Hope this helps,
Lawrence