Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-02 : 08:19:45
|
| BhanuPrakash writes "I got a doubt abt the working of stored procedure. Here is my doubt:If i stop and start my sql server the stored procudeures will be recompiled or not??And where the execution plan will be stored actually??Thanks and regardsBhanuPrakash" |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-02-02 : 09:02:54
|
| Refer to BOL, look up "Execution Plan Caching and Reuse"Andy |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-02 : 09:11:10
|
| I don't believe that topic directly answers the question about stopping and starting SqlServer. My understanding is that after a restart, the SP will be recompiled and the new plan cached on the next execution of the stored procedure, not when the SqlServer restarts.Be One with the OptimizerTG |
|
|
|
|
|
|
StoredProcedures