Temporary user tables, two different connections, same user 1

[CP60]

How can temporary user #table (created through a ADODB connection using the SQLNCLI11 Provider), be accessed by a different program running on the same machine by the same user?

(I already know this can be done with a global temporary ##table).

The connections to the MSSQLS instance are currently using a trusted connection (Integrated Security=SSPI)

Thank you in advance!

 

[Olaf Doschke]

Local temporary tables are visible only in the current session

So there is no way unless you find a way to share the connection/session. A simple thing to try is passing the connection handle to the other EXE, but I doubt that's sufficient.

Bye, Olaf.

 

[CP60]

Ok, thank you for the information!