I ran into a situation where I needed to give exec permission to a user for 100+ sps. After a google I found a few scripts that would do this, problem solved. My question though is what is the best practice in sql server 2005 for users and exec permissions to sps. This seems to be a bit tedious so I feel that I must be doing it wrong.