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
asked Aug 13 '12 at 01:11 PM in Default
@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.
answered Aug 15 '12 at 11:59 AM