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.
__________________________________
