Edit

Share via

sp_helpreplfailovermode (Transact-SQL)

  • Article

Applies to: SQL Server

Displays the current failover mode of a subscription. This stored procedure is executed at the Subscriber on any database. For more information about failover modes, see Updatable Subscriptions - For Transactional Replication.

Transact-SQL syntax conventions

Syntax

sp_helpreplfailovermode
    [ @publisher = ] N'publisher'
    , [ @publisher_db = ] N'publisher_db'
    , [ @publication = ] N'publication'
    [ , [ @failover_mode_id = ] failover_mode_id OUTPUT ]
    [ , [ @failover_mode = ] N'failover_mode' OUTPUT ]
[ ; ]

Arguments

[ @publisher = ] N'publisher'

The name of the Publisher that is participating in the update of this Subscriber. @publisher is sysname, with no default. The Publisher must already be configured for publishing.

[ @publisher_db = ] N'publisher_db'

The name of the publication database. @publisher_db is sysname, with no default.

[ @publication = ] N'publication'

The name of the publication that is participating in the update of this Subscriber. @publication is sysname, with no default.

[ @failover_mode_id = ] failover_mode_id OUTPUT

Returns the integer value of the failover mode. @failover_mode_id is an OUTPUT parameter of type tinyint. It returns 0 for immediate updating and 1 for queued updating.

[ @failover_mode = ] N'failover_mode' OUTPUT

Returns the mode in which data modifications are made at the Subscriber. @failover_mode is an OUTPUT parameter of type nvarchar(10), and can be one of the following values.

Value Description
immediate Immediate updating: updates made at the Subscriber are immediately propagated to the Publisher using two-phase commit protocol (2PC).
queued Queued updating: updates made at the Subscriber are stored in a queue.

Return code values

0 (success) or 1 (failure).

Remarks

sp_helpreplfailovermode is used in snapshot replication or transactional replication for which subscriptions are enabled for immediate updating with queued updating as failover, if there's a failure.

Permissions

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_helpreplfailovermode.

Related content