Posts Tagged ‘audit’

Auditing in TSQL using COLUMNS_UPDATED and XQUERY

Last week I was working on creating an audit trail for CRUD-minus-R (’CRUD-R’ in my own words) operations on certain tables in our application. Two of my objectives are to minimize code intrusion and to capture the before/after values. I decided to do it in database as our application only needs to support SQL Server [...]

Continue reading »