yiqing
Newbie
Points: 1
More actions
April 3, 2002 at 10:41 am
#78777
I heard that all sp_ store procedures will be recompiled everytime you execute them, Is it true?
Andy Warren
SSC Guru
Points: 119902
April 3, 2002 at 11:05 am
#426550
Only if you use the with recompile option. Some stored procedures may end up being recompiled one or more times when executed depending on the code used. Here is one article you might find useful:
http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp
Andy
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply