Re^3: create table is not allowed with in a multi statement transaction

create is an DDL statement which is enabled with autocommit so u need to set the value before executing the create.

Comment on Re^3: create table is not allowed with in a multi statement transaction

Replies are listed 'Best First'.
Re^4: create table is not allowed with in a multi statement transaction by vsudha (Initiate) on Jan 23, 2008 at 15:02 UTC
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?	[reply]