on 10-06-2016 7:47 PM
Hello,
When using SAP Rep Server with multisite availability, assuming we have on source and 2 destinations db's and there is the need for replicating ddl fom the source, is it necessary to set "ddl in tran" at the replicated db's in the MSA?
Thank you.
Regards
Jose
When RS DSI sends the commands (batched) it wraps in a begin tran ... commit / rollback depending on success or failure.
So if DDL ( on source ) is replicated in the same way inside a transaction on target, will you not need the DB option to allow "ddl in tran" ?
Also note that unlike DML which is executed by maintenance user (usually aliased as dbo), DDL is executed with orginal login name.
HTH
Avinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mark,
Thank you
Regards
Jose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.