-
Urgent. Problem with my own sp
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
-
Urgent. Problem with my own sp (reply)
"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
-
Urgent. Problem with my own sp (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|