If I dont drop temp tables before my stored procedure ends, do the temp tables continue to exist? I thought as soon as the session is finished the temp tables are dropped.
Temp tables live past the end of stored procedure execution - they live until the connection in which they were created is disconnected.
Global temp tables (temp tables with double # -
CREATE TABLE ##globalTempTable ...) live until all connections that have referenced them are disconnected, irrespective of what happens on the connection that created them.
No one has followed this question yet.