Hello!

> If I paste the code for the stored procedure in the query window it runs
in
> 10 secs. If from the query window I say execute sp parm1,parm2,parm3 it
then
> takes over 9 minutes. So I would think that the number of rows returned
over
> the network does not impact this problem.

Perhaps your Query Analyser has been configured to return a limited set of
rows?

with regards
anders l. borum � [EMAIL PROTECTED]
the sphereworx / monoliner experience
--


---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to