Article: Troubleshooting Stored Procedure Recompilation

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.

Published Sunday, March 21, 2004 7:03 PM by RoyOsherove
Filed under: ,

Comments

Sunday, March 21, 2004 12:24 PM by TrackBack

# Take Outs for 21 March 2004.

Take Outs for 21 March 2004.
Sunday, March 21, 2004 7:48 PM by Darrell

# re: Article: Troubleshooting Stored Procedure Recompilation

"You don't have to DROP temp tables at the end of the sproc. They will be dropped automatically when the sproc finishes."

- As long as they were created within that proc.