I want to create an audit trail system in my db but only on certain tables and columns. I know I can do:
IF UPDATE(col1)
.
.
IF UPDATE(col2)
.
etc, etc
what I whant to do is pull in the list of updated columns from the triggering command so I can use a table to control the auditted columns...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.