Whats a generic audit trail trigger to track table activity?
Writing a generic audit trail trigger in SQL Server can be a bit tricky, as it requires manipulation of a bitmask exposed by the COLUMNS_UPDATED function. You’ll also need to figure out how to store disparate data types in some generic fashion, which might be difficult if your database uses TEXT, NTEXT, or IMAGE columns. Luckily, SQL Server MVP Nigel Rivett has already done most of the work. You can find his audit trigger at Nigel’s Web site. Adam Machanic, SQL Server 2005 Expert Return to SQL Server tables FAQs 8.
Related Questions
- If a Hopkins physician earns credit elsewhere by attending or participating in a CME activity, is Hopkins going to track these credits for him/her?
- Does Z-TAP track more than the first attempt to read or change a table with the AUDIT ALL or AUDIT CHANGES clause?
- Does TechExcel ServiceWise track the entire audit trail of an issue?
