Great question, learned something today.

Got it right but didn't know that by recompiling the table only the statement referencing that table inside the SP would be recompiled!!

I recently watched one of SQLSentry's videos on query tuning in which they stated that if a table was recompiled all "objects" that depend on a table would be recompiled so I figured the whole SP would recompile. My thought was that the entire execution plan would be thrown away and recreated.

Thanks!