Aug 27, 2007

dbcc freeprocecache

You can use "dbcc freeprocecache" to clear up the procedure cache to ensure the compilation will take place afterwards. How ever it has its drawback, because it will delete the contents of the procedure cache, and all statements and stored procedures will have to be compiled anew.