Troubleshoot SQL P2P replication doesn't replicate DDL schema change.

Question

Post reply

Troubleshoot SQL P2P replication doesn't replicate DDL schema change.

charlesjuy

SSC Rookie

Points: 32
More actions
October 16, 2014 at 12:13 am

#297515

Comments posted to this topic are about the item Troubleshoot SQL P2P replication doesn't replicate DDL schema change.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Misha_SQL SSCertifiable Points: 5407 More actions · Answer 1

Misha_SQL

SSCertifiable

Points: 5407

October 16, 2014 at 4:23 pm

#1752998

Good to know! Thank you for sharing.

baabhu SSCertifiable Points: 6205 More actions · Answer 2

Thank you very much for your post. We had similar problem in production server that was not been able to find the root cause for quite a while. We did so many tests with P2p replication. Finally I gave up. I never thought about the triggers though. Good catch.

Thanks again.

quackhandle1975 SSChampion Points: 11055 More actions · Answer 3

Good article, nice problem solving.

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]