You can use create subscription with the without materialization clause to activate a subscription when materialization has already occurred. To use this method:
The subscription data must already exist at the replicate database
The primary and replicate tables must be synchronized
Activity must be stopped on the primary table so that there are no further updates in the Replication Server stable queues
When creating a subscription with the without materialization clause, Replication Server logs in to the primary Replication Server as the user creating the subscription. The user who executes create subscription must have the same login and password at the primary and replicate Replication Servers.
You can also use create subscription with the without materialization clause to subscribe to function replication definitions.
