Re: Stored procedure and Query Analyser give different results
- From: Mark Stevens <nevyn@xxxxxxxxxxxxx>
- Date: Thu, 27 Aug 2009 20:45:11 +0100
On Thu, 27 Aug 2009 04:28:31 -0700 (PDT), "dean.cochrane@xxxxxxxxx"
<dean.cochrane@xxxxxxxxx> wrote:
On Aug 26, 9:15 pm, Mark Stevens <ne...@xxxxxxxxxxxxx> wrote:
We are using SQL 2008.
This problem is intermittent in that this is the second time we've
seen it now. The first time it was with us for two days and then life
returned to normal. It's has now returned and has been with us for
over a week.
Try recompiling the procedure, either by dropping and recreating it or
by calling sp_recompile.
The actual SP uses temporary tables and I was under the impression
that temporary tables forced a recompilation every time. If I am
wrong then please confirm this.
Regards,
Mark
--
|\ _,,,---,,_ A picture used to be worth a
ZZZzzz /,`.-'`' -. ;-;;, thousand words - then along
|,4- ) )-,_. ,\ ( `'-' came television!
'---''(_/--' `-'\_)
Mark Stevens (mark at thepcsite fullstop co fullstop uk)
This message is provided "as is".
.
- Follow-Ups:
- Re: Stored procedure and Query Analyser give different results
- From: dean.cochrane@xxxxxxxxx
- Re: Stored procedure and Query Analyser give different results
- References:
- Stored procedure and Query Analyser give different results
- From: Mark Stevens
- Re: Stored procedure and Query Analyser give different results
- From: Gert-Jan Strik
- Re: Stored procedure and Query Analyser give different results
- From: Mark Stevens
- Re: Stored procedure and Query Analyser give different results
- From: dean.cochrane@xxxxxxxxx
- Stored procedure and Query Analyser give different results
- Prev by Date: Re: Capture Temp Table Data
- Next by Date: Re: monitor BegineExecuteNonQuery
- Previous by thread: Re: Stored procedure and Query Analyser give different results
- Next by thread: Re: Stored procedure and Query Analyser give different results
- Index(es):
Relevant Pages
|
