Aug 26 2021 06:13 AM
Aug 27 2021 05:42 AM
Every object (table, SP) with a name starting with # is a local temporary object and can only be accessed with in the session where the temp object was created.
Example: In SSMS open 2 query windows, in one you create a temp table with
create table #test (id int null); insert into #test (id) values (1);
And now try to query the temp table in the second query window, like
select * from #test;
You get the same error message.