Thanks for the reply. In my case it may be beneficial. I'm trying to weigh whether or not to add the WITH RECOMPILE to these procedures. Sometimes they're called with little data passed in and sometimes with lots. Based on your thoughts, the procedure may be recompiling the execution plan each time; which in my case is preferred.

Is there a way to watch through Profiler to see that the plan is recompiled?

Thanks

ST