Stored Procedure

Are stored procedures are precompiled in SQL Server.

John.

Not for some time now. A stored procedure is checked for syntax and basic
object references. It's not compiled until it's executed. At that point the
query plan (the compiled executable) is cached and reused until it's flushed
from the server for some reason.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________


"Jonathan Lurie" <Jonathan@nospam.com> wrote in message
news:%23TSLI3GwFHA.552@TK2MSFTNGP12.phx.gbl...
> Are stored procedures are precompiled in SQL Server.
>
> John.
>