COLUMNS_UPDATED() for audit triggers

Posted by Piotr Rodak on SQL Blogcasts See other posts from SQL Blogcasts or by Piotr Rodak
Published on Wed, 28 Apr 2010 22:27:00 GMT Indexed on 2010/04/28 22:48 UTC
Read the original article Hit count: 453

In SQL Server 2005, triggers are pretty much the only option if you want to audit changes to a table. There are many ways you can decide to store the change information. You may decide to store every changed row as a whole, either in a history table or as xml in audit table. The former case requires having a history table with exactly same schema as the audited table, the latter makes data retrieval and management of the table a bit tricky. Both approaches also suffer from the tendency to consume...(read more)

© SQL Blogcasts or respective owner

Related posts about Tips and Tricks

Related posts about t-sql