Connection pooling (with any modern version of SQL Server) will call sp_reset_connection
when reusing a connection. This stored proc, among other things, drops any temporary tables that the connection owns.
Connection pooling (with any modern version of SQL Server) will call sp_reset_connection
when reusing a connection. This stored proc, among other things, drops any temporary tables that the connection owns.