Yep, I have read this info. It was a different article. But, we don't do any of the things listed in those four bullets. I have check to see and nothing recompiles. And, we run a whole payroll engine using this methodology.
BOb
>You need to be careful here. Referencing a temporary table that was created outside of the stored procedure can cause the stored procedure to be recompiled.
>
>
http://www.sql-server-performance.com/rd_optimizing_sp_recompiles.asp>
>-Mike
>
>
>>Margret,
>>
>>I usually use a TEMP table for this. You can create the temp table in your SP, and any SP's you call from that one will be able to access the table.
>>
>>For more info on temp tables see the SQL BOL.
>>
>>BOb