On Thu, May 05, 2005 at 10:26:52PM -0700, Rocky Castaneda wrote:

> Whenever I would execute a stored procedure I notice
> that the CPU Process reaches almost 100% though the
> stored proc has already completed its process.
>
> Any comments, workaround on this issue?

Can you see which process is hogging all the CPU (client or server)? Do
you get the same behaviour if you execute the stored procedure in isql
or something similar?

Could you post a small working example?

Gabriel