I am working on an asp.net application which uses quite a few sql 2005 procedures. Due to some change in requirement I had to modify a couple of the procedures.
During this change, I found that most of the procedures contain clause With Recompile, Execute As Caller.
I am planning to refactor the code in procedure but not sure if I can remove these clauses. Can any one please help me with these?
Thanks in advance.
View Complete Post