Looks like you need change data capture then, which is a SQL Enterprise only feature, either that or create custom triggers on the tables in question to log to an audit database.