Stored procedure recompile caused by alter table on temp table

Stored procedure recompile caused by alter table on temp tablehttp://blogs.msdn.com/b/psssql/archive/2011/07/15/stored-procedure-recompile-caused-by-alter-table-on-temp-table.aspxLately we got a customer who called in and reported  that a particular statement involving a temp table always got recompiled and caused performance problems.   We have a KB article http://support.microsoft.com/kb/243586   which documentsen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)re: Stored procedure recompile caused by alter table on temp tablehttp://blogs.msdn.com/b/psssql/archive/2011/07/15/stored-procedure-recompile-caused-by-alter-table-on-temp-table.aspx#10245360Thu, 08 Dec 2011 02:17:05 GMT91d46819-8472-40ad-a661-2c78acb4018c:10245360M. Kokoy<p>How about creating an index on the temp table inside SP, will be recompile as well?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10245360" width="1" height="1">re: Stored procedure recompile caused by alter table on temp tablehttp://blogs.msdn.com/b/psssql/archive/2011/07/15/stored-procedure-recompile-caused-by-alter-table-on-temp-table.aspx#10187093Fri, 15 Jul 2011 23:32:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:10187093Paul White<p>Interesting, Jack.  But why?  Is this a bug, limitation, or deliberate design?</p> <p>Paul</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10187093" width="1" height="1">