|
SQLServer 2008 Instance My client enabled Change Data Capture in lieu of keeping a history of changes in the baseline table. My challenge is that I need to determine if anything changed since the last time I executed. I have the following logic:
If there are no changes that have the specific lsn values in my table, the Any suggestions on how to get around this?
(comments are locked)
|
|
From MSDN:
(comments are locked)
|
|
Clarification: I guess more specifically, I know why I'm getting the 208 return code but how to I get data from the CDC table when I have a date not a specific lsn for that CDC table?
(comments are locked)
|
|
I started with the following link: http://technet.microsoft.com/en-us/library/cc645858.aspx See if that Validating LSN Boundaries section at the top helps you at all.
(comments are locked)
|
|
I changed the begin date to the start of the data in the table and was successful. Thomas
(comments are locked)
|
|
I changed the begin date to be in the range of the data entered into the table and the error went away. Thomas
(comments are locked)
|
1 2 next page »

