Viewing a Replication Server Subscription

To view a Replication Server subscription, use the following procedure.

Open Enterprise Explorer, and connect to your replicate Replication Server.
Expand the view for your Replication Server connection profile, and expand the view for the replicate database containing the replication subscription you want to view.
Expand the Subscriptions folder, right-click the subscription you want to view, and choose View from the context menu. The SQL for this subscription appears in SQL Editor.

You cannot edit a subscription in SQL Editor. To make alterations to an existing subscription, you must drop the subscription and recreate it.