>Frank,
>
>I can't answer for #1 but as far as security is concerned, you just need to grant 'execute' rights to the user that will be used for your web app. For mine, it is 'NT Authority\Network Service'.
>
Bob,
just to repeat the question:
>>Does this mean that I need to go through each stored proc one by one and add Execute rights?
Did you have to go to each stored procedure to grant the execute rights? If not how do I do this?