Actually it's "WITH RECOMPILE"

You forgot one.. are ou using the same set of parameters for both procs?

Well, it is .

Hence why I asked to see it .

I'll keep using my dts task... far less complicated .

Dude it's just not the way to program in sql, you relly need to get aquinaed with these article.

The Curse and Blessings of Dynamic SQL

Create a local copy of all the parameters used in the query, copy the parameters' value to the local variables and use those variables in the query.

You can search for...

Check out the script section, a much more complete script could do all those operations and much more.

Can you show us the code for the conversion?

You also need to learn sql programming. This is basically the worst possible way to use sql server's stored proc. You need to create one statement for each...

SysIndexes are not reliable, those stats are not always up to date. Count(*) is the only safe solution for this problem if accuracy is required.

Do the whole thing in dyn sql..

can you post your current code?

Still requires 2 passes, and there's no way around that.

DLL problem is either a bug or a bad driver version. Reinstall might take care of it.

Did you try reinstalling the sql server objects (qa, em...).