Your comment about SPROCS not being pre-compiled caught me off guard. Looking into it I guess they never were, based on the post. Learn something new everyday.

http://www.scarydba.com/2009/09/30/p...-fact-or-myth/