sp_helpreplfailovermode (Transact-SQL)
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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru