Hi,
Working thru this KB article and it's links usually will identify the problem.
>Hi,
>
>Anyone faces this issue, of why the same SP in SQL2k SP4
>when initially run, is fast and okay.
>
>However, when i run it the second time or more, it just
>keep getting slower from 30seconds to 2minutes.
>
>Anyone know who or how it is happening.
>
>My SP just using a cursor and even when
>I change it to using loop, it does not
>help.
>
>Thank you
Regards N Mc Donald