Allow Execution of all Stored Procedures in a Schema

Older versions of SQL Server did not have a role that allowed execution of all stored procedures. You can get around this by granting EXECUTE on an entire schema:

GRANT EXECUTE ON SCHEMA :: dbo TO [username]