>Hi everyone...
>I've a table that is used as log of updates made in other tables by the users through the applications... Triggers were created in every single table I'd like to have update control... Today I know the moment that a table was modified and who (user) did it... But I also need to know which columns where modified and this is my problem... If I put a UPDATED() statement inside the trigger i think maybe my application will loose performance (because i will fill it with IFs)... Does anybody know how to log changes made in a table and in its columns? Has someone done this yet?
>
>Thankz...
Take a look at SQLAudit 2.0 at
http://www.redmatrix.com/default.asp?section=sqlaudit. You can download evaluation version from them.
--sb--