• this does not work as explained with SQL 2008 R2.

    sp or not, the local version of the stored procedure is executed first.