on 09-19-2014 5:55 PM
Hi Guys
Actually, we have a MSA (multisite) configuration on replication server 15.6, this configuration has one primary site and two secondary replicate sites.
When an stored procedure is executed and inside it has a temporary table, the connection that tries to replicate this procedure falls down
How can we dismiss this problem?
Is this posible on Rep Server 15.7?
Thank you for your help
Best Regards
Jairo, any news? Was the suggested solution helpful?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You should try to configure temporary the option "ddl in tran" on the tempdb of the replicate databases. In my case it replicates well when I create a new procedure with temp tables on the primary db server. Do not forget to remove this option after being replicated.
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.