Field Level Auditing using Change Data Capture - Part 1

  • Again (being the 4th person to ask), can I / how do I determine the user that made the change? Tx.

  • I was implementing this example and found what appears to be a bug in the [spgGetCDCContract] stored procedure. In it, there is a LEFT JOIN to a table called "Users" which doesn't exist.

    LEFT JOIN Users

    ON Users.user_id = fn_cdc_get_all_changes_dbo_contract.last_change_id

    I'm not sure what needs to be done to fix this as without it, a user_name field in the CDC field list is also invalid.

    Obviously, I can comment that part out. I just wanted to make sure I wasn't missing something...


Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply