The following setting will cause the error:

SET IMPLICIT_TRANSACTIONS ON

If this is turned on, the create table statement will also be rolled back, causing the error.