in reply to Re^3: create table is not allowed with in a multi statement transaction
in thread create table is not allowed with in a multi statement transaction
If I use $dbh->do(create table #test(id int)) to create temporary object in tempdb database. I am not able to see and perform operations in tempdb database on this table #test. It is giving error as "#test not found". But If I use $dbh->do(create table test(id int)) the table exists in my current database on which operations can be performed.
Is there something which I am missing?