1. User attempts to create tables via scripts/commands in the Toad's Editor or if the table is created through the Database Browser, clicking on it's Data tab also results in the following error:
"ERROR [HY000] [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database."
2. Same error occurs with Native Sybase driver when running a script which includes a CREATE TABLE statement AND AUTO-COMMIT is switched off
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center