|
I want to retrieve data that has changed over a certain time period, I use the following query: Problem is, when I set When I put So far so good, well not good, but clear. Weirdest is, it works fine for any date, before or after CDC was enabled (even before WWII works fine) on my colleagues machine. Anybody got an idea where the issue might lie? I would like to be able to set the begin time to any time I please (obviously I wont get the changes from before cdc was enabled, but thats not the point). I just dont want any unexpected error messages when I run this script on a client machine. I primarily use Server 2008R2, but I have the same issue in server 2012. Thanks, Wouter
(comments are locked)
|
|
have a read of this blog, it may help answer you're question... Thanks for the pointer Chris. I had come across that blog myself, while it helped me pinpoint the problem, it doesnt explain why my colleague doesnt have this problem. Nor does it give a workable solution to use pre-cdc-enabled dates.
Aug 15 '12 at 08:05 AM
wouterp
I can't answer the question about why it works on your colleagues machine (different servicepack/CU perhaps??). Can you not perhaps find what the minimum startdate is and change anything that precedes that date to be the fromdate instead and pass that through?
Aug 15 '12 at 09:10 AM
swirl80
(comments are locked)
|
|
@swirl80, yeah that is the only way to go, far as I can see. Since its all implemented in C#, its not difficult to do so (not that its particularly difficult in sql lol). Nonetheless, I dont like unexplained differences in the execution of identical scripts. For the record, machine set ups are pretty similar, at least where the Server installation is concerned. Although on second thought, my colleagues machine is 32 bits, mine is 64. Can that make a difference? I can hardly imagine it, but its the only difference I can find.
(comments are locked)
|

