hi patrick,

i totally agree with elisabeth.

in my opinion it is no good idea to give a user permission to tables because of security problems.

a proc creates an execution plan when it is created and then only uses this plan to be executed. so normally it is not that slow. please make sure, that you have checked if the table needs an index.

you can alter the proc and implement the "with recompile" clause and then exec the proc once. after this, a new execution plan should be generated . then alter the procedure again, so that you don't have the with recomplie clause in your procedure. (otherwise it will always compile, which is not the effect you want to have).

alter proc xy

@x int

with recompile

as

good luck,

sue