is it possible to choose which connection the editor should use among the pooled connections?
When I hover on connection manager, it shows me that there are currently 3 connections in pool, 1 unused and two reserved:
When I execute sp_who2, I see that the SPID is 66. How can I get back the connection with SPID 152?
Why do I need this: I need to reach a temporary table which I created using the other connection. This happens when I start another query while creating the temporary table.