#temp in SQL 2000 (MSDE) 1

[Niv3k]

I didn't explicitly DROP #temp at the end of a procedure, and the next time I ran it, it gave me an error message that the table was still there. I added the DROP #temp now, but I thought a temp table was automatically destroyed when the process it was created by terminated... I guess I'm wrong on this, can someone explain to me how temp tables are stored in memory?

 

[Antzz]

The temporary tables are there in memory unless SQL Server connection is dropped before the next execution of your procedure. So you should drop the table just before your procedure ends in order to clear the memory before the next execution.

 

[Niv3k]

ahhh... okay, that makes sense. Thanks!

Kevin