I tried to set this application up in a 64-bit environment, but I ran into this error below, which I did not get when I previously set this up in...

BOL says that IN is a logical operator. Can you please explain why you considered it as a Predicate? Since most of us answered it "wrong", I think we deserved...

I don't agree with this. Anyone here who can explain why it was answered this way?

Haven't seen this registry entry though in one of my servers that needed a reboot the last time I patched my servers. :w00t:

Apparently, there are missing SPs in your posted code, one of them was spGetDIRExists. Can you please post them too?

Thanks in advance.

🙂

I would say bandwidth is a critical factor here.

Hi Ola,

I tried using your IndexOptimize, but it didn't return any results against my database which is running on compatibility level of 80. I don't think said comp. level is...

May I know what version of .NET was reinstalled? I ahve both versions 1.0 and 2.0 in our server.