>If you created a temp table in SP, you can not access this temp table outside the SP.
>
>That's not entirely correct. If I start a transaction from .NET, and that transaction runs stored procedure A (which creates temp table ABC), and then runs stored procedure B, stored procedure B will see the temp table.
>
>Temp table scope is based on connection, not a single stored procedure

I've run this test:

use AllTests
go
create procedure FirstProc 
  as
create table #Test (id int identity, String varchar(10))
insert into #Test
values ('test1'),('test2')
go

create procedure SecondProc 
  as
select * from #Test
go

execute FirstProc
execute SecondProc

The second procedure was not able to see #Test table.

If I would change my test and call second SP from the first SP, then it will see the temp table. But you were trying to discuss the first scenario, right?