Compile store procedures

[Tony]

I'm having a excessive amount of lock timeout and I discover that every time
when users execute store procedures, these procedures are compile before
execution. Anyone has an idea about this behaviour ?

thank you for your help....

[SriSamp]

Check this link:
[url]http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q243/5/86.ASP&NoWebContent=1[/url]
--
HTH,
SriSamp
Please reply to the whole group only!

"Tony" <news@hotmail.com> wrote in message
news:%23l0Kxh8PDHA.2424@tk2msftngp13.phx.gbl...

> I'm having a excessive amount of lock timeout and I discover that every

time

> when users execute store procedures, these procedures are compile before
> execution. Anyone has an idea about this behaviour ?
>
> thank you for your help....
>
>

[Arun[Symbiosis]]

Arun replies

Check the definition of stored procedure

If the stored procedure definition has the with recompile
option it will compile everytime you try to execute

Regards
Arun

>-----Original Message-----
>I'm having a excessive amount of lock timeout and I

discover that every time

>when users execute store procedures, these procedures are

compile before

>execution. Anyone has an idea about this behaviour ?
>
>thank you for your help....
>
>
>.
>