How to: View and Modify Pull Subscription Properties (SQL Server Management Studio)

View pull subscription properties from the Publisher or the Subscriber in the Subscription Properties - <Publisher>: <PublicationDatabase> dialog box, which is available from Microsoft SQL Server Management Studio. More properties are visible from the Subscriber, and properties can be modified at the Subscriber. You can also view properties from the Publisher on the All Subscriptions tab, which is available in Replication Monitor. For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor).

To view pull subscription properties from the Publisher in Management Studio

  1. Connect to the Publisher in Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Publications folder.

  3. Expand the appropriate publication, right-click a subscription, and then click Properties.

  4. View properties, and then click OK.

To view and modify pull subscription properties from the Subscriber in Management Studio

  1. Connect to the Subscriber in Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Subscriptions folder.

  3. Right-click a subscription, and then click Properties.

  4. Modify any properties if necessary, and then click OK.

To view pull subscription properties from the Publisher in Replication Monitor

  1. Expand a Publisher group in the left pane of Replication Monitor, expand a Publisher, and then click a publication.

  2. Click the All Subscriptions tab.

  3. Right-click a subscription, and then click Properties.

  4. View properties, and then click OK.