>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

-- MS SQL
use AllTests
go
create procedure FirstProc 
  as
insert into #Test
values ('test1'),('test2')
go

create procedure SecondProc 
  as
select * from #Test
go

-- #c
-- call next commands  from #c
create table #Test (id int identity, String varchar(10))
execute FirstProc
execute SecondProc

MartinaJ