Once again I have disappeared from blogging. Let's face it, I rarely get to do it. I also need to upgrade this DasBlog but I have been so busy I haven't been able to do that, even though someone kindly wrote me and told me it would solve my spam comment problem. Maybe this weekend...

But I wanted to blog because I found a weird problem, with a weirder solution. I wrote a Windows service in C# which periodically loads some data, based on the time since the last load. So dates are a bit important in this process.

First, the cryptic message: “Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information”.  A Google search turned up several solutions, but most of them relied on a service patch. What's wierder is that the error was intermittant. The procs would run fine in Query Analyzer, but not from C#.

Finally, I tried the unlikely. Instead of passing in my parameters as  DateTime values, I passed them in as SqlDbType.Varchar, and in the proc made sure and converted them to DateTime values. Lo and behold, the problem went away.....Go figure!