You are correct on words; I used the wrong terms.
>John,
>
>>There are technical factors as well. SPs are precompiled at the server and re-entrant and, therefore, optimizable from the server with little or no intervention.
>
>In SQL server 7 and above there is no such thing as precompilation (it is explicitely stated in the documentation). There is caching of the execution plan when the SP is first run. This also applies to dynamic SQL queries though. So in short there is little difference between SPs and SPT in this respect.
>
>Walter,
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05