O'Reilly logo

Fundamentals of SQL Server 2012 Replication by Sebastian Meine

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6: The Publication Access List

In the previous chapters, we set up distribution and created a publication. With those two pieces in place, all changes to the articles of that publication are recorded and held in the distribution database for later use.

To make use of this collected data, we have to set up a subscription. Before we can create a subscription, however, we need to make sure the necessary permissions are in place.

Setting Up a Subscription

As you learned in Chapter 5, to create a publication in a database, two requirements must be in place:

•   The login used to execute the setup needs to have at least db_owner level permissions in the publication database.

•   The database itself needs to be enabled for publishing. Enabling ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required