Using create subscription for nonatomic materialization

Use the create subscription command with the without holdlock clause to create a subscription with nonatomic materialization. The syntax is:

create subscription subscription
	for table_rep_def
	with replicate at data_server.database
	[where search_conditions]
	without holdlock
	[subscribe to truncate table]

where subscription is the name of the subscription to activate, table_rep_def is the name of the table replication definition you are subscribing to, and data_server.database identifies the replicate database.

Nonatomic materialization is always incremental.

Clients at the replicate site should be suspended or warned that the data in the replicate table is incomplete and possibly inconsistent until all the subscription data has materialized.