Urgent. Problem with my own sp

[Rguardado]

Hi:
Actually I have an app with several sp's, but in sometimes SQL detects that is necessary to
recompile one of my sp's, How can I identify which sp's need to be recompile?.

Somebody knows the possible reason because I'm experimenting this problem.


Thanks in advance

[Greg]

"but in sometimes SQL detects that is necessary to recompile one of my sp's"
what di u mean???. your application gives you error about different versions of same stored proc?or what?

On 2/23/99 12:26:24 PM, Rguardado wrote:
> Hi:
Actually I have an app with several sp's, but in sometimes
> SQL detects that is necessary to
recompile one of my sp's, How can I
> identify which sp's need to be recompile?.

Somebody knows the
> possible reason because I'm experimenting this problem.


Thanks
> in advance

We have SQLServer6.5 and sometimes when My app executes an particular sp it sends an
error message indicating that my sp needs to be recompiled, so I halt my app.
Right now we are verifing our ODBC version, SQL setup, etc but.
I dont know what it's happen, but I check my sp and cant see something wrong or special.

I would like to find some system sp that indicates which sp's are damaged or need to be
recompile.

Also We are change the instruction "EXEC" for agregate the option WITH RECOMPILE


Gracias

On 2/23/99 12:26:24 PM, Rguardado wrote:
> Hi:
Actually I have an app with several sp's, but in sometimes
> SQL detects that is necessary to
recompile one of my sp's, How can I
> identify which sp's need to be recompile?.

Somebody knows the
> possible reason because I'm experimenting this problem.


Thanks
> in advance