EXERCISE 9.2C ONFIGURING P UBLISHER

7. Another important configuration is to configure Articles. As you

can see in Figure 9.5, you have the luxury of replicating not only

tables and views, but also stored procedures and user-defined

functions as well.

Figure 9.5 Publisher Articles

SQL Server requires that all tables referenced by published views

and indexed views be available at the Subscriber. If the referenced tables

are not published as articles in this publication, they must be created

at the Subscriber manually.

In case of transactional replication you are not allowed to select

tables without primary keys to select as articles.