Specify a Materialization Method for Publication Subsciptions

Specify materialization methods for publication subscriptions in the same way you specify materialization methods for regular subscriptions.

When you use create subscription, you can specify atomic, nonatomic, or the no-materialization method. The default method is atomic materialization, using the select with holdlock operation.

Article subscriptions share the name of the parent subscription and generally, its materialization method. However, function replication definitions require the bulk or no-materialization method. If you use create subscription, and articles in the publication reference function replication definitions, Replication Server uses the no-materialization method for these article subscriptions—regardless of the materialization method specified in the publication subscription.

Related reference
Subscription Materialization Methods