If you use the script under the correct DB it should return all the sps which do not have EXECUTE permission.

If you know the trouble making sp, use the below statement to give permission.

GRANT EXECUTE ON TO db_execute