|
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)
|
|
Greg Low raised a Connect issue regarding this: http://connect.microsoft.com/SQLServer/feedback/details/303972/cdc-function-error-messages-are-misleading It's closed as won't fix, but if we all vote it up... (sorry - this should be a comment on the answer, but I don't have the rep.) I've voted you up - which helps you on your way to having the rep required! ;-)
Mar 28 at 09:22 AM
ThomasRushton ♦
(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 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 be in the range of the data entered into the table and the error went away. Thomas
(comments are locked)
|
1 2 next page »

