very very stange SP problem, please help

From: Henok (google_at_henok.com)
Date: 06/29/04 

Date: 29 Jun 2004 14:35:56 -0700

Hello Gurus,

I have a rather strange problem,

I have a stored procedure that I call from an ASP page, when I call
it, it takes about 10-15 seconds to execute and return, however that
same stored procedure executes and gives the result in Query Analyzer
in at most 1 second!

Here is the killer, after I run the ALTER statement on the stored
procedure from Query Analyzer(i don't change anything, i simply
execute the ALTER script), that procedure will be just as fast from my
ASP page!!!! This will last only until I reboot my machine.. after the
reboot, the problem starts again!

Can someone please help me,

Thank you in advance…

Aslo, please post your replies in the News Group, as I no longer
monitor the e-mail google@henok.com

Thank you,

Relevant Pages