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 ...