Page 1 of 1

SP Debug using tempory table created in SQL Editor

Posted: Tue 04 May 2021 19:36
by EduardoFornaro
Hi,

I installed the trial version for testing. I opened a new SQL Editor and created a temporary table. Now I need to debug a Stored Procedure that will use this temporary table. The problem is that the SP debugging window cannot see the temporary table created in the other window (SQL Editor). It looks like they are isolated connections. How can I share the temporay table with my SP?

Grateful,

Edward

Re: SP Debug using tempory table created in SQL Editor

Posted: Fri 14 May 2021 06:32
by dzhanhira
Unfortunally, it's not possible. In order for the temporary table to participate in debugging, it must be created inside the procedure.