sp_help_peerconflictdetection (Transact-SQL)
Applies to: SQL Server
Returns information about the conflict detection settings for a publication that is involved in a peer-to-peer transactional replication topology.
Transact-SQL syntax conventions
Syntax
sp_help_peerconflictdetection
[ @publication = ] N'publication'
[ , [ @timeout = ] timeout ]
[ ; ]
Arguments
[ @publication = ] N'publication'
The name of the publication for which to return information. @publication is sysname, with no default.
[ @timeout = ] timeout
Specifies the amount of time, in seconds, after which the procedure times out while waiting for response from every node in the topology. @timeout is int, with a default of 60
. If there's a read-only Subscriber in the topology, specifying a time-out value isn't valid. Read-only Subscribers never respond to a call from this procedure.
Result set
sp_help_peerconflictdetection
returns three result sets. These results are documented in the following articles:
- MSpeer_conflictdetectionconfigrequest (Transact-SQL)
- MSpeer_conflictdetectionconfigresponse (Transact-SQL)
- MSpeer_originatorid_history (Transact-SQL)
Return code values
0
(success) or 1
(failure).
Remarks
sp_help_peerconflictdetection
is used in peer-to-peer transactional replication.
Permissions
Requires membership in the sysadmin fixed server role, or db_owner fixed database role.
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