Stored Procedures and sp_prepexec

[NervousRex]

we have a SQL stored procedure that is causing an issue when called through coldfusion, it is taking an extremely long time to run....5+ minutes sometimes

The issue is, when run through Query analyzer it runs in 2 secs. I have no other ideas of how to increase the speed of the queries in the SP.

I have run multiple SQL traces, and the only thing I can think of is an issue with coldfusion causing the procedure to run under sp_prepexec instead of calling the SP directly.

If anyone has any tips they can offer I would greatly appreciate it.

 

[TruthInSatire]

code please.

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.