Yep. That only applies for procedures that are created in master and prefixed with sp_

When executed from a database other than master the procedure runs within the context of that database.