Interview Questions
1. Is it possible to have 2 publications with one table in common?
In merge replication the same table may be added to each publication. However, one of the publications will need to be set up as a no-sync and if you are using automatic range management you’ll receive a PK error like this:
“Violation of PRIMARY KEY constraint ‘PK__MSrepl_identity___4D5F7D71′. Cannot insert duplicate key in object
‘MSrepl_identity_range’.”. So you’ll need to use manual range management for your table article.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment