Toad World® Forums

Switching active connection

Dear all,

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:

Bild 7.png

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.

Cheers,

Ercan