I don't think so. I tested in 2005 and truncate is not a cause of recompilation of sp. It may be because of statement level recompiliation feature of sql server 2005. Coluld u pse confirm how about in SQL Server 2000 Madhu