Skip to Content
0
Former Member
Sep 26, 2016 at 05:11 PM

MSA : DDL 'The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'repcheck' database.

271 Views

to i just setup MSA replication ..

1) Database Replication definition

create database replication definition repdef_repcheck

with primary at DS_CTO.repcheck


2) subscription .

create subscription sub_repcheck

for database replication definition repdef_repcheck

with primary at DS_CTO.repcheck

with replicate at DS_STANDBY.repcheck

without materialization

subscribe to truncate table


>>>> Replication working fine but it was not replication DDL ...


3) Alter replication definition

alter database replication definition repdef_repcheck

with primary at DS_CTO.repcheck

replicate DDL


Now getting error :

Message from server: Message: 2762, State 3, Severity 16 -- 'The 'CREATE TABLE' command is not allowed within a multi-statement transaction in the 'repcheck' database.

'.

Do i need to do something on connection level ..

Thanks for your help ...

Thanks

Ajay Pandey