This content has been marked as final. Show 2 replies
Look for the CDC Demos here:1 person found this helpful
They are titled:
Change Data Capture - Synchronous Demo
Change Data Capture - Asynch HotLog Demo
Change Data Capture - Asynch AutoLog Demo
Thank you damorgan, your example was very thorough and helpful. Unfortunately though, after following your steps with my table I was testing, I am still receiving nulls where the insert statement had a space, besides that the asynchronous cdc process works fine.
It is almost like there is a trimming occurring when inserting into the change table, even though in the source table there is a space ' '. I might just need to stay with synchronous CDC because at least the trigger is capturing the correct change data, not sure why the Asynchronous would be different with the space becoming a null.