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...