Mike,
I had tried WITH RECOMPILE to no avail - I don't have the book - so if you happen to find time to look that up, I would be appreciative.
thanks!
Ken
>Ken,
>
>First, you could try executing the stored procedure with the WITH RECOMPILE option, which would cause SQL Server to reoptimize the stored procedure. The original query plan would remain in cache, eventhough the BOL says otherwise.
>
>There are two DBCC commands, neither of which I remember off the top of my head. If you have a copy of Inside SQL Server 7.0 (Delaney), both are covered there. I just don't have my copy handy.
>
>-Mike
>
>
>>Hi,
>>
>>I have a stored proc that drags like crazy "first time each day or session" it is run. After that it runs fine (I assume becuase it is compiled and cached) making it difficult to figure out where the problem is. Is there a command/function that can clear the procedure cache and force this procedure to always act like it is "first time of the day"?
>>
>>TIA,
>>Ken
Ken B. Matson
GCom2 Solutions