How to switch from immediate updating to queued updating as a failover (Transact-SQL)

• Use the sp_setreplfailovermode stored procedure and set the following parameters.

  Parameter	Description
  @publisher	Name of the Publisher.
  @publisher_db	Name of the publication database.
  @publication	Name of the publication.
  @failover_mode	Can be 'immediate', or 'queued'.