This post originated from an RSS feed registered with .NET Buzz by Roy Osherove. Original Post: Article: Troubleshooting Stored Procedure Recompilation Feed Title: ISerializable Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/rosherove/Rss.aspx Feed Description: Roy Osherove's persistent thoughts Latest .NET Buzz Posts Latest .NET Buzz Posts by Roy Osherove Latest Posts From ISerializable

Josh posted about recompilation problems he had when using #temp tables in his sprocs.

He then got a great comment from Roman referring to this article : Troubleshooting Stored Procedure Recompilation

One more little tidbit: You don't have to DROP temp tables at the end of the sproc. They will be dropped automatically when the sproc finishes.