This week I’m attending SQLPass, and Monday was the first Pre-Con day. I had the pleasure of sitting in “A Day of SSIS in the Enterprise” presented by Andy Leonard (blog|twitter), Tim Mitchell (blog|twitter) and Matt Mason (blog|twitter). Having spent a significant time in SSIS already and even had thanked a few people, including Andy, [...]
Continuing the CDC debugging posts: Intro First Problem Now that I have the StartLSN and EndLSN I was ready to go. Hit my breakpoint and the variables were set appropriately. Woo-hoo! Then…wait a minute…what? vSQLQuery.Value = “SELECT ” + ” c.__$operation ” + ” , c.Column1 ” + ” , c.Column2 ” + ” , [...]
So now that we have the idea let’s look as the four main problems I encountered: The first problem I noticed was that the SQL query that was running still had nulls in on the StartLSN and EndLSN so I was querying: cdc.fn_cdc_get_net_changes_<instance name> (null, null, ‘all’) Which as I said last post, returns an [...]