This feature will be removed in a future version of Microsoft SQL Server.
Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
After you do, however, you cannot return to immediate updating until the Subscriber and Publisher are connected and the Queue Reader Agent has applied all pending messages in the queue to the Publisher.
This feature remains supported in versions of SQL Server from 2012 through 2016.
When an updating subscription to a transactional publication supports failover from one updating mode to another, you can programmatically switch update modes to handle situations when connectivity changes for a short period of time.
This topic describes the deprecated Replication features that are still available in SQL Server 2012.
These features are scheduled to be removed in a future release of SQL Server.
If you create a transactional publication with updatable subscriptions in the New Publication Wizard, both immediate updating and queued updating are enabled.
If you create a publication with stored procedures, you can enable one or both options.