This is the first time I have seen where an old thread (more than 3 yrs) get some interest. 🙂

Check this article out[/url]. The second part of it shows the main reason why sp_ is costy and sp is not.