And I am getting the error as "create table command is not allowed with in a multi-statement transaction".

But I am not issuing multiple statements and I didn't keep it in a transaction. Then why is is that I am getting this error.

When I searched about this error I came to know that if "ddl in tran" is set to true then this error can be handled. Is there no other solution to this one, like executing as a single statement and not keeping it in a transaction.