A good question. I missed my point, because I once again made the mistake of trusting the documentation.

http://technet.microsoft.com/en-us/library/ms181647.aspx says that if sp_recompile specifies a table or view, all the stored procedures or triggers that reference the table or view will be recompiled the next time that they are run (emphasis mine). It doesn't mention that this is actually a statement-level recompile.

Great to know - never needed this until now, but you never know when it comes in handy. Thanks, Mikael! 😉