Sybase Philippines

hi to all admin

help naman baka na encouter nyo na tong message nato "create table is not allowed multi- statement transaction tempdb" on your ASE

and how to fix this ! thank you

Hi Teng,(sorry if i got it wrong)
SQL commands, such as Data Definition Language (DDL) commands ar not allowd inside a multi-statment transaction unless you turn on the db option 'ddl in tran'

You might be creating a table inside a transaction.so don't use begin tran and create a table.create the table outside the multiple transaction.


Hope this helps.

Let me know if you need more info on this.

Thanks,
Tim
SybaseTeam-Sybase,Unix Forums Member