Interview Questions

1. Can the same objects be published in different publications?

Replication supports publishing articles in multiple publications (including republishing data) with the following restrictions:

  •  If an article is published in a transactional publication and a merge publication, ensure that the @published_in_tran_pub property is set to TRUE for the merge article.
  •  An article cannot be published in both a merge publication and a transactional publication with queued updating subscriptions.
  •  Articles included in transactional publications that support updating subscriptions cannot be republished.
  •  Transactional replication and unfiltered merge replication support publishing a table in multiple publications and then subscribing within a single table in the subscription database (commonly referred to as a roll up scenario). Roll up is often used for aggregating subsets of data from multiple locations in one table at a central Subscribe
By Hena Parveen 2 0
Is this helpful? Yes No

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


Check out more interview questions

Based on your skills

MS SQL Server

1659758 1720 23 859

Angular

42397 92 0 46

Wordpress

34278 72 1 36